Re: Errors with temporary tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Errors with temporary tables
Дата
Msg-id 9458.1133187577@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Errors with temporary tables  (Alexander Presber <aljoscha@weisshuhn.de>)
Список 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 по дате отправления:

Предыдущее
От: Alex
Дата:
Сообщение: Help with COPY Error: invalid UTF-8 byte ....
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: Help with COPY Error: invalid UTF-8 byte ....