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

[strk at refractions.net]

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;
-------------- next part --------------
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