Re: Errors with temporary tables - Mailing list pgsql-general

From Tom Lane
Subject Re: Errors with temporary tables
Date
Msg-id 9458.1133187577@sss.pgh.pa.us
Whole thread Raw
In response to Errors with temporary tables  (Alexander Presber <aljoscha@weisshuhn.de>)
List pgsql-general
Jens Wendelmuth <jw@weisshuhn.de> writes:
> I'm a newbie with PG and i do not understand the meaning of "a table's rowtype not getting dropped when the table is
> dropped."

Every table has an associated composite type of the same name, which
represents the type of each row of the table.  This type entry should
go away automatically if the table is dropped.  We've seen a few trouble
reports that look like that mechanism failed for some reason, but no one
yet has any clue why.

> Is this a failure of us or PG(8.1.0)?
> Is there a way to solve/workaround this error?

It's certainly not your fault, but with so little information about
what's happening or what causes it, it's hard to say how to fix it
or avoid it.  If you can come up with a test case that lets other
people reproduce the problem, I'm sure we could fix it in short order...

            regards, tom lane

pgsql-general by date:

Previous
From: Alex
Date:
Subject: Help with COPY Error: invalid UTF-8 byte ....
Next
From: Richard Huxton
Date:
Subject: Re: Help with COPY Error: invalid UTF-8 byte ....