Re: reldesc does not exit

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. Currently this is
just a demo version of the application, but the production version is
planned to be rolled out within a month and the volume of records held in
this table will eventually get up to 1 million.

I added the definition of the table below.

Any direction that you can give me to help me hunt this down is greatly
appreciated. I am still pretty new at all of this.

Thank you very much!
Darrin

CREATE TABLE foo (
bar varchar,
last_category_cde varchar,
last_bite_cnt int,
last_page_cnt int,
last_site_cnt int,
dtd_category_cde varchar,
dtd_bite_cnt int,
dtd_page_cnt int,
dtd_site_cnt int,
dtd_run_cnt int,
dtd_categ_1 varchar,
dtd_rating_1 int,
dtd_categ_2 varchar,
dtd_rating_2 int,
dtd_categ_3 varchar,
dtd_rating_3 int,
wtd_category_cde varchar,
wtd_bite_cnt int,
wtd_page_cnt int,
wtd_site_cnt int,
wtd_run_cnt int,
wtd_categ_1 varchar,
wtd_rating_1 int,
wtd_categ_2 varchar,
wtd_rating_2 int,
wtd_categ_3 varchar,
wtd_rating_3 int,
mtd_category_cde varchar,
mtd_bite_cnt int,
mtd_page_cnt int,
mtd_site_cnt int,
mtd_run_cnt int,
mtd_categ_1 varchar,
mtd_rating_1 int,
mtd_categ_2 varchar,
mtd_rating_2 int,
mtd_categ_3 varchar,
mtd_rating_3 int,
tot_category_cde varchar,
tot_bite_cnt int,
tot_page_cnt int,
tot_site_cnt int,
tot_run_cnt int,
tot_categ_1 varchar,
tot_rating_1 int,
tot_categ_2 varchar,
tot_rating_2 int,
tot_categ_3 varchar,
tot_rating_3 int,
last_bite_dte timestamp,
added_dte timestamp,
CONSTRAINT pk_foo
PRIMARY KEY (bar)
);
-----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 12:40 AM
Subject: Re: [GENERAL] reldesc does not exit

>"Darrin Ladd" <dladd(at)newfoundcomm(dot)net> writes:
>> I continually get the following error when I truncate a very large table
in
>> my db:
>> NOTICE: trying to delete a reldesc that does not exist
>> Is this something that I should be concerned about?
>
>Possibly. That's a "shouldn't ever happen" kind of message, so it
>certainly indicates some sort of bug. Severity of bug is unguessable
>at this point. I don't see this when doing TRUNCATE on a plain-vanilla
>table, so I guess there is something special about your situation.
>What Postgres version are you running, on what platform? May we see
>the full definition of the table in question? Also, how large is "very
>large"?
>
> regards, tom lane