[postgis-tickets] r17809 - shp2pgsql -D not working with schema qualified tables

Regina Obe lr at pcorp.us
Fri Sep 13 02:14:14 PDT 2019


Author: robe
Date: 2019-09-13 14:14:14 -0700 (Fri, 13 Sep 2019)
New Revision: 17809

Modified:
   trunk/NEWS
   trunk/loader/shp2pgsql-core.c
Log:
shp2pgsql -D not working with schema qualified tables
Closes #4504

Modified: trunk/NEWS
===================================================================
--- trunk/NEWS	2019-09-13 15:40:41 UTC (rev 17808)
+++ trunk/NEWS	2019-09-13 21:14:14 UTC (rev 17809)
@@ -1,5 +1,5 @@
 PostGIS 3.0.0alpha5
-XXXX/XX/XX
+2019/XX/XX
 For full changes and enhancements, refer to PostGIS 3.0.0.
 This version requires PostgreSQL 9.5+-12 and GEOS >= 3.6+
 Additional features enabled if you are running Proj6+ and PostgreSQL 12
@@ -12,6 +12,7 @@
   - #4496, Make ST_Simplify(TRIANGLE) collapse if requested (Raúl Marín)
   - #4501, Allow postgis_tiger_geocoder to be installable by non-super users (Regina Obe)
   - #4503, Speed up the calculation of cartesian bbox (Raúl Marín)
+  - #4504, shp2pgsql -D not working with schema qualified tables
 
 PostGIS 3.0.0alpha4
 2019/08/10

Modified: trunk/loader/shp2pgsql-core.c
===================================================================
--- trunk/loader/shp2pgsql-core.c	2019-09-13 15:40:41 UTC (rev 17808)
+++ trunk/loader/shp2pgsql-core.c	2019-09-13 21:14:14 UTC (rev 17809)
@@ -1509,10 +1509,10 @@
 		else {
 			if (state->config->schema)
 			{
-				stringbuffer_aprintf(sb, " \"%s\".\" ", state->config->schema);
+				stringbuffer_aprintf(sb, " \"%s\".", state->config->schema);
 			}
 
-			stringbuffer_aprintf(sb, " \"%s\" (%s) FROM stdin;\n", state->config->table, state->col_names);
+			stringbuffer_aprintf(sb, "\"%s\" (%s) FROM stdin;\n", state->config->table, state->col_names);
 		}
 
 		/* Copy the string buffer into a new string, destroying the string buffer */



More information about the postgis-tickets mailing list