need help

[Bekir Niyaz]

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.



ERROR:  type "geometry" does not exist at character 98
QUERY:  SELECT ST_FlipCoordinates(st_setsrid(st_geogfromtext(replace(new.tesiskoordinat,',','.')),4326)::geometry)



it is a simple insert into sql, it throws only when inserted via hibernate,

postgis installed in public schema and

user has search_path= public, another_schema

table has select priviliges on public.spatial_ref_sys





when I check installed extention with \dx the output

  postgis            | 3.0.4   | public     | PostGIS geometry, geography, and raster spatial types and functions


but when run select Postgis_Version();

 3.3 USE_GEOS=1 USE_PROJ=1 USE_STATS=1

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20240403/975140fc/attachment.htm>