Opened 11 days ago
#5720 new defect
shp2pgsql no longer renaming system column names xmin, xmax
| Reported by: | turntwo463 | Owned by: | robe |
|---|---|---|---|
| Priority: | high | Milestone: | PostGIS 3.4.3 |
| Component: | utils/shp2pgsql | Version: | 3.4.x |
| Keywords: | xmin, xmax | Cc: |
Description
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
Zip of sample shapefile to exhibit issue