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
обсуждение исходный текст
Ответы Re: drop table cascade doesn't drop manual sequences  ("Scott Marlowe" <scott.marlowe@gmail.com>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Andrus"
Дата:
Сообщение: Invalid error message when user has nologin attibute
Следующее
От: "detrox yang"
Дата:
Сообщение: Re: how to ignore invalid byte sequence for encoding without using sql_ascii?