Re: invisible dependencies on a table?

Поиск
Список
Период
Сортировка
От Tim Uckun
Тема Re: invisible dependencies on a table?
Дата
Msg-id CAGuHJrNSsdEOCyZJ68HSkD54omiqah8R6bTtFA=D=kev9QQZbQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: invisible dependencies on a table?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general

As I've marked here, both default expressions are depending on the
sequence, but there's only one "ownership" dependency of the sequence
on a column.  To complete the switchover you'd need to use ALTER SEQUENCE
... OWNED BY ... to move that ownership dependency to the new table.
Then the old table (and its default) could be dropped without affecting
the new table.


I did an alter sequence after the table renaming and it works now. Thanks for all your help. 

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: invisible dependencies on a table?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Unexpected update behaviour