Re: reldesc does not exit - Mailing list pgsql-general

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


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