[HACKERS] Cache lookup failed for relation 16905 ??

2002-11-02 Thread Steve Howe
Hello all, I got a weird behavior testing PostgreSQL 7.3b3. The query below was run in a FreeBSD 4.4 system, on a fresh install and just I just had made an initb. No classes created at all. howe=# select p.oid, n.nspname, pg_get_userbyid(p.proowner), proname from pg_proc as p, pg_namespace as n

Re: [HACKERS] Cache lookup failed for relation 16905 ??

2002-11-02 Thread Tom Lane
Steve Howe [EMAIL PROTECTED] writes: I got a weird behavior testing PostgreSQL 7.3b3. The query below was run in a FreeBSD 4.4 system, on a fresh install and just I just had made an initb. No classes created at all. howe=# select p.oid, n.nspname, pg_get_userbyid(p.proowner), proname from

Re: [HACKERS] Cache lookup failed for relation 16905 ??

2002-11-02 Thread Steve Howe
Hello Tom, Saturday, November 2, 2002, 11:26:56 AM, you wrote: TL Steve Howe [EMAIL PROTECTED] writes: I got a weird behavior testing PostgreSQL 7.3b3. The query below was run in a FreeBSD 4.4 system, on a fresh install and just I just had made an initb. No classes created at all. howe=#

Re: [HACKERS] Cache lookup failed for relation 16905 ??

2002-11-02 Thread Tom Lane
Steve Howe [EMAIL PROTECTED] writes: howe=# select p.oid, n.nspname, pg_get_userbyid(p.proowner), proname from pg_proc as p, pg_namespace as n where pg_table_is_visible(p.oid); However, this situation lead me into another issue. The new conversion functions (utf8_to_big5, iso_to_alt, etc.)

Re: [HACKERS] Cache lookup failed for relation 16905 ??

2002-11-02 Thread Steve Howe
Hello Tom, Saturday, November 2, 2002, 5:17:29 PM, you wrote: TL Steve Howe [EMAIL PROTECTED] writes: howe=# select p.oid, n.nspname, pg_get_userbyid(p.proowner), proname from pg_proc as p, pg_namespace as n where pg_table_is_visible(p.oid); However, this situation lead me into another