Re: [HACKERS] PostGreSQL v6.2.1 for Linux Alpha

> --- SearchSysCache starts here ---
> SearchSysCache: [KTH] Hash: 433
> SearchSysCache: [KTH] Tuple not found in cache, attempting to find.
> SearchSysCache: [KTH] RelationGetRelationName (pg_proc)
> SearchSysCache: performing scan (override==0)
> SearchSysCache: [KTH] IsBootstrapProcessingMode() is true
> SearchSysCache: [KTH] relation check skipped.
> SearchSysCache: [KTH] heap_beginscan is okay.
> heap_getnext([pg_proc,nkeys=3],backw=0,0x1ffff040) called
> heap_getnext returning EOS
> SearchSysCache: [KTH] heap_getnext returns null
> SearchSysCache: [KTH] tuple not found.
> SearchSysCache: [KTH] Heap scan ends.
> SearchSysCache: Heap tuple (ntp) is invalid.
> ERROR: BuildFuncTupleDesc: function mkoidname(opaque, opaque) does not exist
> ERROR: BuildFuncTupleDesc: function mkoidname(opaque, opaque) does not exist
> --- End of debug ---

The problem here is that it can't find the function to make/use the
index. Try using initdb --debug to get more output, and see what is
says about the mkoidname function creation. Looks like pg_proc is not
working, because a scan is returning nothing. mkoidname is function
used to index pg_attribute. If you do initdb with --noclean, is
data/template1/pg_proc indeed zero bytes. Try adding a define to the
postgres.h

#define long int

and see if it works. Maybe the 64-bit longs are causing problems, and
we have to fix them or change to ints.

Make sure you turn on Assert checking in configure so it may give you an
earlier error.

These are very hard to debug because there is no running system to run
tests on, and it is all very inter-related.

My lib/local1_template1.bki.source has the following two lines for this
function:

insert OID = 949 ( mkoidname PGUID 11 f t f 2 f 911 "26 19" 100 0 0 100 foo bar)
declare index pg_attribute_relid_attnam_index on pg_attribute using btree(mkoidname(attrelid, attname) oidname_ops)

That is all the ideas I have for now. Would like to get it working.

--
Bruce Momjian
maillist(at)candle(dot)pha(dot)pa(dot)us