I'd check to make sure hibernate has usage rights and execute for all functions.
I recall they changed that in PG 15 I think it was. From: Bekir Niyaz <bagaf...@hotmail.com> Sent: Wednesday, April 3, 2024 4:52 AM To: postgis-users@lists.osgeo.org Subject: need help 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
