Jens Wendelmuth <jw@xxxxxxxxxxxx> 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