[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