Error when using 'Copy Table to...' if table includes Geometry field
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: