Stijn Goedertier (
https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=639c49032aac389d02c2a9bf
) *created* an issue
GeoServer (
https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiMWFkMDEyZWYxNmE4NDMzYjk2OTM0YzU5Y2Y5N2ZiNWMiLCJwIjoiaiJ9
) / Bug (
https://osgeo-org.atlassian.net/browse/GEOS-10796?atlOrigin=eyJpIjoiMWFkMDEyZWYxNmE4NDMzYjk2OTM0YzU5Y2Y5N2ZiNWMiLCJwIjoiaiJ9
) GEOS-10796 (
https://osgeo-org.atlassian.net/browse/GEOS-10796?atlOrigin=eyJpIjoiMWFkMDEyZWYxNmE4NDMzYjk2OTM0YzU5Y2Y5N2ZiNWMiLCJwIjoiaiJ9
) TaskManager CopyTable produces PSQLException zero-length delimiter (
https://osgeo-org.atlassian.net/browse/GEOS-10796?atlOrigin=eyJpIjoiMWFkMDEyZWYxNmE4NDMzYjk2OTM0YzU5Y2Y5N2ZiNWMiLCJwIjoiaiJ9
)
Issue Type: Bug Assignee: Unassigned Created: 16/Dec/22 12:07 PM Environment:
We use the TaskManager CopyTable task to update postgres tables from a source
database.
This works well on most of our tables, but for some the copying fails with this
error:
org.postgresql.util.PSQLException: ERROR: zero-length delimited identifier at
or near """" Position
This is caused by the fact that the source table contains columns that have
been dropped.
In the logs of postgres we find the following error:
ERROR: zero-length delimited identifier at or near """" at character 68
Statement: CREATE TABLE "public"."_temp_27cb54af_cc35_491a_8236_b2f4e258685a" (
"".""."".""."".""."".""."pg"."dropped"."1" - NULL, "id" bigint, "geom"
geometry(MultiPolygon,31370) NULL, "id" bigint NOT NULL, PRIMARY KEY("id") )
It shows that TaskManager CopyTable tries to create a table with a “dropped”
column.
This information indeed occurs in the postgres pg_attribute metadata.
SELECT a.attname, a.attisdropped, c.relname FROM pg_attribute a LEFT JOIN
pg_class c ON (a.attrelid = c.oid)
WHERE c.relname = 'mytable'
attname | attisdropped | relname
------------------------------+--------------+----------------
id | f | mytable
........pg.dropped.1........ | t | mytable
another attribute | f | mytable
...
(21 rows)
Priority: Medium Reporter: Stijn Goedertier (
https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=639c49032aac389d02c2a9bf
)
(
https://osgeo-org.atlassian.net/browse/GEOS-10796#add-comment?atlOrigin=eyJpIjoiMWFkMDEyZWYxNmE4NDMzYjk2OTM0YzU5Y2Y5N2ZiNWMiLCJwIjoiaiJ9
) Add Comment (
https://osgeo-org.atlassian.net/browse/GEOS-10796#add-comment?atlOrigin=eyJpIjoiMWFkMDEyZWYxNmE4NDMzYjk2OTM0YzU5Y2Y5N2ZiNWMiLCJwIjoiaiJ9
)
Get Jira notifications on your phone! Download the Jira Cloud app for Android (
https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100212-
sha1:e2fc486 )_______________________________________________
Geoserver-devel mailing list
Geoserver-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
