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.