Re: [HACKERS] initdb problem

I should be clear. This 'grep' was done in pgsql/src/include/catalog
directory.

> OK. I did a little checking:
>
> #$ cd /pg/include/catalog/
> #$ grep 683 *.h
> #$ grep 682 *.h
> #$ grep 681 *.h
> pg_proc.h:DATA(insert OID = 681 ( oid8gt PGUID
> 11 f t f 2 f 16 "30 30" 100 0 0 100 foo bar ));
>
> #$ sql test
> seleWelcome to the POSTGRESQL interactive sql monitor:
> Please read the file COPYRIGHT for copyright terms of POSTGRESQL
>
> type \? for help on slash commands
> type \q to quit
> type \g or terminate with semicolon to execute query
> You are currently connected to the database: test
>
> ctest=> select * from pg_proc where oid = 683
> test-> \g
> proname|proowner|prolang|proisinh|proistrusted|proiscachable|pronargs|proretset|prorettype|proargtypes|probyte_pct|properbyte_cpu|propercall_cpu|prooutin_ratio|prosrc|probin
> -------+--------+-------+--------+------------+-------------+--------+---------+----------+-----------+-----------+--------------+--------------+--------------+------+------
> (0 rows)
>
>
> Your system is complaining about a lookup of 683. Part of the problem
> is that there is no reference to that number in the system catalog
> stuff, nor on my running system. Now I will say that 681 is one of the
> new functions I added to allow indexing of the oid8 field. My guess is
> that somewhere you have something with that number in your source, and
> it should not be there.
>
> Try reproducing my 'grep' and see if you get anything. If you do, the
> somehow you have an old copy of the source.
>
> --
> Bruce Momjian | 830 Blythe Avenue
> maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
> + If your life is a hard drive, | (610) 353-9879(w)
> + Christ can be your backup. | (610) 853-3000(h)
>
>

--
Bruce Momjian | 830 Blythe Avenue
maillist(at)candle(dot)pha(dot)pa(dot)us | Drexel Hill, Pennsylvania 19026
+ If your life is a hard drive, | (610) 353-9879(w)
+ Christ can be your backup. | (610) 853-3000(h)