drop table cascade doesn't drop manual sequences

Поиск
Список
Период
Сортировка
Искать
От
Guilherme
Тема
drop table cascade doesn't drop manual sequences
Дата
Msg-id
1192065784.614950.90140@50g2000hsm.googlegroups.com
Список
Дерево обсуждения
drop table cascade doesn't drop manual sequences Guilherme <antoniolo@gmail.com>
Re: drop table cascade doesn't drop manual sequences "Scott Marlowe" <scott.marlowe@gmail.com>
Re: drop table cascade doesn't drop manual sequences Tom Lane <tgl@sss.pgh.pa.us>
Re: drop table cascade doesn't drop manual sequences Andreas Kretschmer <akretschmer@spamfence.net>
Re: drop table cascade doesn't drop manual sequences Tom Lane <tgl@sss.pgh.pa.us>
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

В списке pgsql-general по дате отправления
От: Andrus
Дата:
От: detrox yang
Дата:
FAQ