From b01cca1a222453fc1eaa112b1578206db569fab5 Mon Sep 17 00:00:00 2001 From: Sandro Santilli Date: Wed, 15 Dec 2004 12:59:40 +0000 Subject: [PATCH] Enforced schema use in UpdateGeometrySRID git-svn-id: http://svn.osgeo.org/postgis/trunk@1151 b70326c6-7e19-0410-871a-916f4a2858ee --- lwgeom/lwpostgis.sql.in | 10 ++++++++++ 1 file changed, 10 insertions(+) diff --git a/lwgeom/lwpostgis.sql.in b/lwgeom/lwpostgis.sql.in index d54bb7c6b..5cd1f6683 100644 --- a/lwgeom/lwpostgis.sql.in +++ b/lwgeom/lwpostgis.sql.in @@ -2685,7 +2685,12 @@ BEGIN cname = ''enforce_srid_'' || column_name; -- Drop enforce_srid constraint +#if USE_VERSION < 73 EXECUTE ''ALTER TABLE '' || quote_ident(table_name) || +#else + EXECUTE ''ALTER TABLE '' || quote_ident(real_schema) || + ''.'' || quote_ident(table_name) || +#endif '' DROP constraint '' || quote_ident(cname); -- Update geometries SRID @@ -2700,7 +2705,12 @@ BEGIN '', '' || new_srid || '')''; -- Reset enforce_srid constraint +#if USE_VERSION < 73 EXECUTE ''ALTER TABLE '' || quote_ident(table_name) || +#else + EXECUTE ''ALTER TABLE '' || quote_ident(real_schema) || + ''.'' || quote_ident(table_name) || +#endif '' ADD constraint '' || quote_ident(cname) || '' CHECK (srid('' || quote_ident(column_name) || '') = '' || new_srid || '')''; -- 2.40.0