Opened 7 months ago
Closed 6 months ago
#5720 closed defect (fixed)
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
Attachments (1)
Change History (4)
by , 7 months ago
Attachment: | small_example.7z added |
---|
comment:3 by , 6 months ago
Resolution: | → fixed |
---|---|
Status: | new → closed |
Zip of sample shapefile to exhibit issue