Opened 5 years ago

Closed 4 years ago

#4665 closed defect (worksforme)

ST_intersects fails on windows

Reported by: autra Owned by: pramsey
Priority: medium Milestone: PostGIS 3.0.3
Component: postgis Version: 3.0.x
Keywords: Cc:

Description

When restoring a dump from postgresql9.4/postgis2.1 on windows, it fails when refreshing some materialized views with this error 

pg_restore: de l'entrée TOC 36071 ; 0 2909195 MATERIALIZED VIEW DATA bar Emilie
pg_restore: erreur : could not execute query: ERREUR:  no spatial operator found for 'st_intersects': opfamily 2905696 type 2905583
La commande était : REFRESH MATERIALIZED VIEW bar;

I have no idea how to troubleshoot this, so sorry if this is missing relevant informations.

It looks like some of the comments of ​https://trac.osgeo.org/postgis/ticket/4608 but robe explicitly said st_intersects works for them, so posting a new issue here instead.

Change History (2)

comment:1 by Algunenano, 4 years ago

Milestone: → PostGIS 3.0.3

comment:2 by pramsey, 4 years ago

Resolution: → worksforme
Status: new → closed

Without reproduction instructions, I cannot do anything on this. There was a legitimate fix in the other ticket which may or may not affect this on patch release.

Note: See TracTickets for help on using tickets.