Re: Unable to drop a table due to seemingly non-existent dependencies

Поиск
Список
Период
Сортировка
От David Brain
Тема Re: Unable to drop a table due to seemingly non-existent dependencies
Дата
Msg-id 849c74160909101418wa014859yc990bfd001b8ac56@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Unable to drop a table due to seemingly non-existent dependencies  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi,

On Thu, Sep 10, 2009 at 2:55 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:

>
> The "ownership" link is still there, evidently, and should be switched
> to the new table.  Read up on ALTER SEQUENCE OWNED BY.
>
>                        regards, tom lane
>

Thank you - that was the issue, once the ownership was switched to the
new tables I was able to drop the old ones.  That's certainly
something I've learned about Postgres today.

David

В списке pgsql-general по дате отправления:

Предыдущее
От: Pavel Stehule
Дата:
Сообщение: Re: Getting the oid of an anyelement
Следующее
От: Grant Maxwell
Дата:
Сообщение: Re: "show all" command crashes server