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@sss.pgh.pa.us>
To: Darrin Ladd <dladd@newfoundcomm.net>
Cc: PGSQL General <pgsql-general@postgresql.org>
Date: Friday, September 29, 2000 10:35 AM
Subject: Re: [GENERAL] reldesc does not exit


>"Darrin Ladd" <dladd@newfoundcomm.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