| From: | Tim Uckun <timuckun(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, David Johnston <polobo(at)yahoo(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: invisible dependencies on a table? |
| Date: | 2013-12-14 21:33:07 |
| Message-ID: | CAGuHJrNSsdEOCyZJ68HSkD54omiqah8R6bTtFA=D=kev9QQZbQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2013-12-14 22:36:58 | Re: Unexpected update behaviour |
| Previous Message | Adrian Klaver | 2013-12-14 20:18:28 | Re: invisible dependencies on a table? |