Postgres Pro
Downloads
Home   >   mailing lists

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

From David G. Johnston
Subject Re: BUG #15962: Cannot drop table that previously had a 'serial' column
Date
Msg-id CAKFQuwbpUZbxXV696JKa5VukS6DmotfrvU2XX1duNNx1gipCMQ@mail.gmail.com
Whole thread Raw
In response to BUG #15962: Cannot drop table that previously had a 'serial' column  (PG Bug reporting form <noreply@postgresql.org>)
Responses Re: BUG #15962: Cannot drop table that previously had a 'serial' column
List pgsql-bugs
Tree view


On Fri, Aug 16, 2019, 4:25 PM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the 

Looking at the properties of the sequence I still see it tied to the older
table
Column  d2_search_history_2019050.search_id     auto
Column  d2_search_history.search_id     normal

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?

David J.

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15962: Cannot drop table that previously had a 'serial' column
Next
From: PG Bug reporting form
Date:
Subject: BUG #15963: DB Connection Error at regular time periods