Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #6683: dropping a table with a serial column from an extension needs to explicitely drop the associated seq - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #6683: dropping a table with a serial column from an extension needs to explicitely drop the associated seq
Date
Msg-id 5280.1339280042@sss.pgh.pa.us
Whole thread Raw
In response to BUG #6683: dropping a table with a serial column from an extension needs to explicitely drop the associated seq  (phb.emaj@free.fr)
Responses Re: BUG #6683: dropping a table with a serial column from an extension needs to explicitely drop the associated seq
List pgsql-bugs
Tree view 
phb.emaj@free.fr writes:
> When a table having a seial column has been created by a CREATE EXTENSION,
> and when this table is later dropped from the extension, the associated
> sequence must be also explicitely dropped from the extension.

This doesn't really seem like a bug to me.  The sequence is a somewhat
independent object.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Jaime Casanova
Date:
Subject: Re: BUG #6680: error para ingresar
Next
From: Tom Lane
Date:
Subject: Re: BUG #6682: pg_dump and sequence values of serial columns for extension configuration tables