Re: reldesc does not exit

Sorry, don't know why I felt I should change the table's name.

The table's name is spider and the oid is 443616.

Uh oh, yes, I do get the same notice when truncating other tables, even
tables not in the same database :(

-----Original Message-----
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Darrin Ladd <dladd(at)newfoundcomm(dot)net>
Cc: PGSQL General <pgsql-general(at)postgresql(dot)org>
Date: Friday, September 29, 2000 10:35 AM
Subject: Re: [GENERAL] reldesc does not exit

>"Darrin Ladd" <dladd(at)newfoundcomm(dot)net> writes:
>> I have Postgres 7.0.2 installed on an Alpha running Red Hat Linux 6.2.
The
>> table is truncated and loaded with approximately 40,000 records per day.
>> The load is done by performing a COPY FROM. The first time it was ever
>> loaded, the load was done using insert statements, with autocommit on and
>> the box froze half way through. Ever since then, every time the
truncation
>> is performed, the reldesc warning has been displayed.
>
>Hm. Nothing out-of-the-ordinary about your table definition or what
>you're doing with it, and 40K records is certainly not anything that's
>going to stress the system.
>
>An Alpha, on the other hand, is not such a common platform. I am
>thinking that there is probably some 64-bit portability bug lurking
>in the hashtable code that manages the reldesc cache. It might be
>dependent on the exact table name and/or OID. Could you tell us the
>real name of this table (I assume it's not "foo") and the OID (do
>"select oid from pg_class where relname = 'table name'")? Do you
>see the same notice when you do a TRUNCATE on other tables?
>
>Does anyone else running an Alpha see this sort of notice when doing
>a TRUNCATE TABLE?
>
> regards, tom lane