[postgis-tickets] r17061 - Missed a spot in last commit
Regina Obe
lr at pcorp.us
Thu Nov 22 11:49:50 PST 2018
Author: robe
Date: 2018-11-22 23:49:49 -0800 (Thu, 22 Nov 2018)
New Revision: 17061
Modified:
branches/2.5/postgis/postgis.sql.in
Log:
Missed a spot in last commit
Closes #4231 for postgis 2.5.2
Modified: branches/2.5/postgis/postgis.sql.in
===================================================================
--- branches/2.5/postgis/postgis.sql.in 2018-11-22 21:10:50 UTC (rev 17060)
+++ branches/2.5/postgis/postgis.sql.in 2018-11-23 07:49:49 UTC (rev 17061)
@@ -5541,7 +5541,9 @@
CREATE OR REPLACE FUNCTION postgis_constraint_srid(geomschema text, geomtable text, geomcolumn text) RETURNS integer AS
$$
SELECT replace(replace(split_part(s.consrc, ' = ', 2), ')', ''), '(', '')::integer
- FROM pg_class c, pg_namespace n, pg_attribute a, pg_constraint s
+ FROM pg_class c, pg_namespace n, pg_attribute a
+ , (SELECT connamespace, conrelid, conkey, pg_get_constraintdef(oid) As consrc
+ FROM pg_constraint) AS s
WHERE n.nspname = $1
AND c.relname = $2
AND a.attname = $3
More information about the postgis-tickets
mailing list