Error when using 'Copy Table to...' if table includes Geometry field Follow
Answered
When moving tables between Postgres databases using the 'Copy Table to..' the process fails if the table includes a geometry column. I works if the geometry is removed.
When defining the new table schema I am ensuring to set these fields type as geometry(Point, 3857) etc.
The process begins, then stops with the following message:
15:02 Connected
15:02 create tbl_name
(
col geometry(Polygon, 3857),
col serial,
col numeric(1000),
col numeric(1000),
col geometry(Point, 4326),
col numeric(1000),
col numeric(1000)
)
15:02 Connected
15:02 Connected
15:02 Connected
15:02 Connected
15:12 database@host: tbl_name imported to tbl_name: 0 rows (10 m 0 s 80 ms)
15:12 java.rmi.UnmarshalException: Error unmarshaling return header; nested exception is:
java.net.SocketException: Connection reset
15:12 Connected
15:12 java.net.ConnectException: Connection refused: connect
15:13 Connected
15:13 Connected
15:13 drop table tbl_name
15:13 Connected
Please sign in to leave a comment.
@Chris Storey,
There are issues you can vote for and follow: