BUG #7802: Cannot drop table because of dependant sequence, but there is link to sequence

From: cwillemsen(at)technocon(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7802: Cannot drop table because of dependant sequence, but there is link to sequence
Date: 2013-01-10 11:25:38
Message-ID: E1TtGGQ-0000m0-U8@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 7802
Logged by: Christiaan Willemsen
Email address: cwillemsen(at)technocon(dot)com
PostgreSQL version: 9.1.7
Operating system: CentOS 6.2
Description:

I have a table that currently looks like this:

CREATE TABLE old_table
(
id bigint DEFAULT 0
)

Thats's it..

So, now when I drop the table is sais:

ERROR: cannot drop table old_table because other objects depend on it
DETAIL: default for table old_table column id depends on sequence
old_table_id_seq
HINT: Use DROP ... CASCADE to drop the dependent objects too.

But clearly, that is not the case... This was however the case. This table
was a partitioned table. I made a copy of the table to de-partition it, and
reused the old sequence of the new table, then removed the sequence from the
old table id. So for some reason Postgresql still thinks that the DEFAULT of
this id is still connected to the sequence. I already tried changing the
DEFAULT, truncate the table, drop all other columns, remove constraints and
indexes, vacuum full, basically all I could think of. Still, it wont work.

I don't want to drop the sequence in question, since it is in active use in
the new table.

I did exactly the same thing for another table that I de-partitioned, but
there I had not problems.

So how can I fix this?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2013-01-10 16:10:22 Re: BUG #7802: Cannot drop table because of dependant sequence, but there is link to sequence
Previous Message Rodrigo Rosenfeld Rosas 2013-01-10 01:09:18 Re: wrong search_path being used