Re: invisible dependencies on a table? - Mailing list pgsql-general

From Tim Uckun
Subject Re: invisible dependencies on a table?
Date
Msg-id CAGuHJrNSsdEOCyZJ68HSkD54omiqah8R6bTtFA=D=kev9QQZbQ@mail.gmail.com
Whole thread Raw
In response to Re: invisible dependencies on a table?  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: invisible dependencies on a table?
Next
From: Tom Lane
Date:
Subject: Re: Unexpected update behaviour