Re: Errors with temporary tables

Jens Wendelmuth <jw(at)weisshuhn(dot)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