serial drop error

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: serial drop error
Date: 2004-12-05 19:34:43
Message-ID: 200412051234.44036.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following queries result in a dropped sequence, but IMO should not:

create table foo(id serial);
create table bar(id integer not null nextval('foo_id_seq'::text));
alter table foo alter column id drop default;
drop table foo;

Once dependence between foo and foo_id_seq has been removed, a drop of foo
should not drop foo_id_seq, particularly if someone else is using it as a
default. This occurs in 7.3.4 and 7.4.6.

Ed

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-12-05 19:45:38 Re: Configure error on Openssl with Beta5
Previous Message Devrim GUNDUZ 2004-12-05 19:34:30 Re: Configure error on Openssl with Beta5