Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #15962: Cannot drop table that previously had a 'serial' column - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #15962: Cannot drop table that previously had a 'serial' column
Date
Msg-id 23617.1566018101@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #15962: Cannot drop table that previously had a 'serial' column  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-bugs
Tree view 
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Fri, Aug 16, 2019, 4:25 PM PG Bug reporting form <noreply@postgresql.org>
> wrote:
>> Any suggestions on how to remove the dependency it still has ?  or will I
>> have to make a New sequence for the new table and call it ?

> Alter sequence?

ALTER SEQUENCE ... OWNED BY, in particular, should help here.

            regards, tom lane

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15963: DB Connection Error at regular time periods
Next
From: PG Bug reporting form
Date:
Subject: BUG #15964: vacuumdb.c:187:10: error: use of undeclared identifier 'FD_SETSIZE'