<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-9">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<p class="elementToProof" style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, sans-serif; font-size: 12pt; color: black;">Hello again I updated postgis from 3.0 to 3.3 but didn't execute "alter extension postgis UPDATE;" and restart db. The
query was working well but after update it starts throwing errors below. </span></p>
<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, sans-serif; font-size: 12pt; color: black;"> </span></p>
<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, sans-serif; font-size: 12pt; color: black;">ERROR: type "geometry" does not exist at character 98<br>
QUERY: SELECT ST_FlipCoordinates(st_setsrid(st_geogfromtext(replace(new.tesiskoordinat,',','.')),4326)::geometry)</span></p>
<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, sans-serif; font-size: 12pt; color: black;"> </span></p>
<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, sans-serif; font-size: 12pt; color: black;">it is a simple insert into sql, it throws only when inserted via hibernate, </span></p>
<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, sans-serif; font-size: 12pt; color: black;">postgis installed in public schema and</span></p>
<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, sans-serif; font-size: 12pt; color: black;">user has search_path= public, another_schema </span></p>
<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, sans-serif; font-size: 12pt; color: black;">table has select priviliges on public.spatial_ref_sys</span></p>
<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, sans-serif; font-size: 12pt; color: black;"> </span></p>
<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, sans-serif; font-size: 12pt; color: black;"> </span></p>
<p style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, sans-serif; font-size: 12pt; color: black;">when I check installed extention with \dx the output</span></p>
<p class="elementToProof" style="margin: 0cm 0cm 0.0001pt;"><span style="font-family: Calibri, sans-serif; font-size: 12pt; color: black;"> postgis | 3.0.4 | public | PostGIS geometry, geography, and raster spatial types and functions</span></p>
<p class="elementToProof" style="margin: 0cm 0cm 12pt;"><span style="font-family: Calibri, sans-serif; font-size: 12pt; color: black;"><br>
</span></p>
<p class="elementToProof" style="margin: 0cm 0cm 12pt;"><span style="font-family: Calibri, sans-serif; font-size: 12pt; color: black;">but when run select Postgis_Version();</span></p>
<p class="elementToProof" style="margin: 0cm 0cm 12pt;"><span style="font-family: Calibri, sans-serif; font-size: 12pt; color: black;"> 3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1<br>
<br>
</span></p>
</body>
</html>