[postgis-users] Substantial different index use between 9.5 and 9.6 using Postgis

Sandro Santilli strk at kbt.io
Sun Dec 4 02:17:57 PST 2016


On Sun, Dec 04, 2016 at 02:46:03PM +1100, Bill Measday wrote:
> This looks odd. Here is what pgAdmin tells me if is the current definition
> of st_setsrid (cost of 1.0)
> 
> CREATE OR REPLACE FUNCTION public.st_setsrid(
>     geog geography,
>     srid integer)
>     RETURNS geography
>     LANGUAGE 'c'
>     COST 1.0
>     IMMUTABLE NOT LEAKPROOF STRICT
> AS '$libdir/postgis-2.3', 'LWGEOM_set_srid'
> ;
> 
> However using you new definition still seems to have fixed the issue.

The one you just showed is for *geography*, while Regina fixed
the one for *geometry*.

--strk;


More information about the postgis-users mailing list