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)
Список
Дерево обсуждения
invisible dependencies on a table? Tim Uckun <timuckun@gmail.com>
Re: invisible dependencies on a table? David Johnston <polobo@yahoo.com>
Re: invisible dependencies on a table? Tim Uckun <timuckun@gmail.com>
Re: invisible dependencies on a table? Tom Lane <tgl@sss.pgh.pa.us>
Re: invisible dependencies on a table? Adrian Klaver <adrian.klaver@gmail.com>
Re: invisible dependencies on a table? Tom Lane <tgl@sss.pgh.pa.us>
Re: invisible dependencies on a table? Adrian Klaver <adrian.klaver@gmail.com>
Re: invisible dependencies on a table? Tom Lane <tgl@sss.pgh.pa.us>
Re: invisible dependencies on a table? Tim Uckun <timuckun@gmail.com>
Re: invisible dependencies on a table? Adrian Klaver <adrian.klaver@gmail.com>
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 по дате отправления
