[PostGIS] #5720: shp2pgsql no longer renaming system column names xmin, xmax
PostGIS
trac at osgeo.org
Fri Apr 26 07:03:38 PDT 2024
#5720: shp2pgsql no longer renaming system column names xmin, xmax
-----------------------------+---------------------------
Reporter: turntwo463 | Owner: robe
Type: defect | Status: new
Priority: high | Milestone: PostGIS 3.4.3
Component: utils/shp2pgsql | Version: 3.4.x
Keywords: xmin,xmax |
-----------------------------+---------------------------
I have previously been using postgis-bundle-pg15-3.3.3x64. After
upgrading to postgis-bundle-pg16-3.4.1x64 (for Windows) some shapefiles no
longer load into PostgreSQL.
Here is the output when trying to load one such table:
Field xmin is an FTDouble with width 19 and precision 11
Field xmax is an FTDouble with width 19 and precision 11
Field id is an FTDouble with width 19 and precision 11
Shapefile type: Point
Postgis type: POINT[2]
SET
SET
BEGIN
ERROR: column name "xmin" conflicts with a system column name
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
ERROR: current transaction is aborted, commands ignored until end of
transaction block
invalid command \.
ERROR: syntax error at or near "2144173.71033000015"
LINE 1: 2144173.71033000015 2144173.71033000015 5571.00000000000 010...
^
ROLLBACK
--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5720>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.
More information about the postgis-tickets
mailing list