Re: [HACKERS] Re: ERROR: index_rescan: invalid amrescan regproc ??? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: [HACKERS] Re: ERROR: index_rescan: invalid amrescan regproc ???
Date
Msg-id 2837.925138495@sss.pgh.pa.us
Whole thread Raw
In response to Re: [HACKERS] Re: ERROR: index_rescan: invalid amrescan regproc ???  (Brian P Millett <bpm@ec-group.com>)
List pgsql-hackers
> I did remove the old & do an "initdb", "createdb test", then reran the :
> java -classpath $MYCLASSPATH example.ImageViewer jdbc:postgresql:test bpm
> foo

> Then I got the following SQLexception.
> ERROR:  index_beginscan: invalid ambeginscan regproc

> Then I did the
> test=> select * from pg_am;
> [ perfectly normal-looking pg_am table ... ]

Hmm.  Nothing wrong with the table that I can see; conclusion is that
its cache image in memory must be messed up.  Perhaps you are indeed
dealing with a platform-specific bug.  Or it could be a memory-clobber
kind of problem (but I'd think lots of people would be reporting strange
behavior if we had one of those on the loose).

You might try building the backend with assert checking turned on
(--enable-cassert) to see if any problems are detected.
        regards, tom lane


pgsql-hackers by date:

Previous
From: jwieck@debis.com (Jan Wieck)
Date:
Subject: Re: [HACKERS] It would be nice if this could be fixed...
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] psql bug ?