Opened 5 years ago

Closed 5 years ago

#4243 closed defect (fixed)

Use of deprecated function in UpdateGeometrySRID

Reported by: robe Owned by: robe
Priority: medium Milestone: PostGIS 3.0.0
Component: postgis Version: master
Keywords: Cc:

Description

tickets .. failed (diff expected obtained: /var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_95_diff)
-----------------------------------------------------------------------------
--- tickets_expected	2018-11-08 12:15:17.205801173 +0000
+++ /var/lib/jenkins/workspace/postgis/tmp/3_0_pg12w64/test_95_out	2018-11-18 23:17:32.358030529 +0000
@@ -125,8 +125,8 @@
 #696|010f000080060000000103000080010000000500000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000f03f0000000000000000000000000000f03f000000000000f03f0000000000000000000000000000f03f0000000000000000000000000000000000000000000000000000000000000000010300008001000000050000000000000000000000000000000000000000000000000000000000000000000000000000000000f03f0000000000000000000000000000f03f000000000000f03f0000000000000000000000000000f03f0000000000000000000000000000000000000000000000000000000000000000000000000000000001030000800100000005000000000000000000000000000000000000000000000000000000000000000000f03f00000000000000000000000000000000000000000000f03f0000000000000000000000000000f03f00000000000000000000000000000000000000000000f03f00000000000000000000000000000000000000000000000001030000800100000005000000000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f00000000000000000000000000000000000000000000f03f000000000000f03f0000000000000000010300008001000000050000000000000000000000000000000000f03f00000000000000000000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000f03f000000000000f03f00000000000000000000000000000000000000000000f03f00000000000000000103000080010000000500000000000000000000000000000000000000000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f000000000000f03f000000000000f03f0000000000000000000000000000f03f000000000000f03f00000000000000000000000000000000000000000000f03f
 #720|MULTIPOINT(-1113194.91 4838471.4,-1113194.91 7326837.72,-1113194.91 11028513.63,556597.45 4838471.4,556597.45 7326837.72,556597.45 11028513.63,2226389.82 4838471.4,2226389.82 7326837.72,2226389.82 11028513.63,3896182.18 4838471.4,3896182.18 7326837.72,3896182.18 11028513.63,5565974.54 4838471.4,5565974.54 7326837.72,5565974.54 11028513.63)
 #723|0101000020e61000006284f068e33826c00000000000004440
-#723|0107000020e610000000000000
-#723|0107000020e610000000000000
+#723|0101000020e6100000000000000000f87f000000000000f87f
+#723|0101000020e6100000000000000000f87f000000000000f87f
 #723|0101000020e61000006284f068e33826c00100000000804b40
 #804|<gml:Point srsName="urn:ogc:def:crs:EPSG::4326"><gml:pos srsDimension="2">0 0</gml:pos></gml:Point>
 #845|t
@@ -205,8 +205,8 @@
 ERROR:  invalid SRID: 999000 not found in spatial_ref_sys
 #1596.5|3395
 NOTICE:  SRID value -1 converted to the officially unknown SRID value 0
-#1596.6|public.road_pg.roads_geom SRID changed to 0
-#1596.7|0
+ERROR:  function postgis_constraint_srid(name, character varying, character varying) does not exist at character 8
+#1596.7|3395
 #1596|Point[GS]
 #1695|MULTIPOLYGON EMPTY
 #1697.1|0

oops after I took out functions marked for deprecation in r17029, ran into this issue.

Change History (3)

comment:1 by robe, 5 years ago

Owner: changed from pramsey to robe

comment:2 by robe, 5 years ago

Summary: Use of deprecated function in ticketsUse of deprecated function in UpdateGeometrySRID

comment:3 by robe, 5 years ago

Resolution: fixed
Status: newclosed

In 17030:

Put back deprecated functions removed in r17029, but patch them to use newer pg_get_constraintdef function.
Also mark them as undeprecated cause they are used in other management functions, and it's too messy to change those to use teh raw sql.
We maybe stuck with these forever :(
Closes #4243 for PostGIS 3.0

Also fix error in raster patching
References #4231 for PostGIS 3.0

Note: See TracTickets for help on using tickets.