[postgis-devel] Re: [postgis-users] bugs in postgis-1.0RC2 with postgres 7.2.1

strk at refractions.net strk at refractions.net
Mon Feb 7 23:51:16 PST 2005


4. probe_geometry_columns() doesn't work

I've fixed this (pg_constraint was called pg_relcheck then)

--strk;

On Mon, Feb 07, 2005 at 02:54:27PM +0100, strk at refractions.net wrote:
> On Mon, Feb 07, 2005 at 05:31:24AM +0200, alex bodnaru wrote:
> (cuts0
> > 1. in run_index_regress, i am getting "ERROR:  fmgr_info: function 0:
> > cache lookup failed", and the index is not been made.
> 
> I've found the bug. The 72 index bindings were using wrong capitalizzation
> for functions.
> It is fixed in CVS.
> Attached is a patch, you'll need to source the scripts again.
> 
> --strk;

> Index: lwgeom/lwpostgis.sql.in
> ===================================================================
> RCS file: /home/cvs/postgis/postgis/lwgeom/lwpostgis.sql.in,v
> retrieving revision 1.110
> retrieving revision 1.111
> diff -U2 -r1.110 -r1.111
> --- lwgeom/lwpostgis.sql.in	1 Feb 2005 16:53:53 -0000	1.110
> +++ lwgeom/lwpostgis.sql.in	7 Feb 2005 14:02:20 -0000	1.111
> @@ -1,5 +1,5 @@
>  -- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>  -- 
> --- $Id: lwpostgis.sql.in,v 1.110 2005/02/01 16:53:53 strk Exp $
> +-- $Id: lwpostgis.sql.in,v 1.111 2005/02/07 14:02:20 strk Exp $
>  --
>  -- PostGIS - Spatial Types for PostgreSQL
> @@ -768,5 +768,5 @@
>        opcamid = (SELECT oid FROM pg_am WHERE amname = 'gist')
>        and opcname = 'gist_geometry_ops'
> -      and proname = 'LWGEOM_gist_consistent';
> +      and proname = 'lwgeom_gist_consistent';
>  
>  INSERT INTO pg_amproc (amopclaid, amprocnum, amproc)
> @@ -776,5 +776,5 @@
>        opcamid = (SELECT oid FROM pg_am WHERE amname = 'gist')
>        and opcname = 'gist_geometry_ops'
> -      and proname = 'LWGEOM_gist_union';
> +      and proname = 'lwgeom_gist_union';
>  
>  INSERT INTO pg_amproc (amopclaid, amprocnum, amproc)
> @@ -784,5 +784,5 @@
>        opcamid = (SELECT oid FROM pg_am WHERE amname = 'gist')
>        and opcname = 'gist_geometry_ops'
> -      and proname = 'LWGEOM_gist_compress';
> +      and proname = 'lwgeom_gist_compress';
>  
>  INSERT INTO pg_amproc (amopclaid, amprocnum, amproc)
> @@ -792,5 +792,5 @@
>        opcamid = (SELECT oid FROM pg_am WHERE amname = 'gist')
>        and opcname = 'gist_geometry_ops'
> -      and proname = 'LWGEOM_gist_decompress';
> +      and proname = 'lwgeom_gist_decompress';
>  
>  INSERT INTO pg_amproc (amopclaid, amprocnum, amproc)
> @@ -800,5 +800,5 @@
>        opcamid = (SELECT oid FROM pg_am WHERE amname = 'gist')
>        and opcname = 'gist_geometry_ops'
> -      and proname = 'LWGEOM_gist_penalty';
> +      and proname = 'lwgeom_gist_penalty';
>  
>  INSERT INTO pg_amproc (amopclaid, amprocnum, amproc)
> @@ -808,5 +808,5 @@
>        opcamid = (SELECT oid FROM pg_am WHERE amname = 'gist')
>        and opcname = 'gist_geometry_ops'
> -      and proname = 'LWGEOM_gist_picksplit';
> +      and proname = 'lwgeom_gist_picksplit';
>  
>  INSERT INTO pg_amproc (amopclaid, amprocnum, amproc)
> @@ -816,5 +816,5 @@
>        opcamid = (SELECT oid FROM pg_am WHERE amname = 'gist')
>        and opcname = 'gist_geometry_ops'
> -      and proname = 'LWGEOM_gist_same';
> +      and proname = 'lwgeom_gist_same';
>  
>  #else // USE_VERSION >= 73

> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users




More information about the postgis-devel mailing list