drop table cascade doesn't drop manual sequences

From: Guilherme <antoniolo(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: drop table cascade doesn't drop manual sequences
Date: 2007-10-11 01:23:04
Message-ID: 1192065784.614950.90140@50g2000hsm.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello folks,

I'm new to postgres and I'm using version 8.1

Here's the problem anyway:

If I insert a sequence later on table creation with alter table, drop
table cascade simply doesn't drop this sequence even when I specify
CASCADE.

works
####################

create table bla(id serial);
drop table bla CASCADE;
select * from pg_class were relkind = 'S' => nothing

doesn't
####################

create table bla(id integer);
create sequence bla_id_seq;
alter table bla alter column id set default nextval('bla_id_seq');

drop table bla CASCADE;
select * from pg_class were relkind = 'S' => 'bla_id_seq'

Is this supposed to happen or am I missing something?

Thanks in advance,
Guilherme

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Randall Lucas 2007-10-11 01:49:59 Coercing compound types to use generic ROW comparison operators
Previous Message Luis Vargas 2007-10-11 00:47:41 fmgr_info_cxt_security() modifies variable?