PostGIS 3.6.1 - ERROR: operator is not unique: public.geometry = public.geometry

[Paul Ramsey]

On Thu, Jan 8, 2026 at 9:15 AM Regina Obe <lr at pcorp.us> wrote:

> Cedric,
>
>
>
> Good news.  I was able to replicate.
>
>
>
> I noticed in your output you have the fully qualified type name, which
> means you don’t have postgis schema in your search path.
>
>
>
> To replicate I did:
>
>
>
> set search_path='pg_catalog';
>
> SELECT 'POINT EMPTY'::public.geometry = 'POINT EMPTY'::public.geometry;
>
>
>
>
>
> Gives:
>
>
>
> ERROR: operator is not unique: public.geometry = public.geometry LINE 1:
> SELECT 'POINT EMPTY'::public.geometry = 'POINT EMPTY'::publi... ^
>
>
>
>
>
> So I’m guessing we have some code in our = path that is not schema
> qualified.
>
>
>
> I’ve ticketed the issue here:
>
>
>
> https://trac.osgeo.org/postgis/ticket/6033
>
>
>
> Paul,
>
> Can you confirm you can replicate by changing your search_path?
>
>
>

Yes, that replicates on my pg18 also.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20260108/aec3f20d/attachment.htm>