Re: drop table problem - Mailing list pgsql-general

From Tom Lane
Subject Re: drop table problem
Date
Msg-id 22821.1043443570@sss.pgh.pa.us
Whole thread Raw
In response to drop table problem  ("frank_lupo" <frank_lupo@email.it>)
List pgsql-general
"=?utf-8?Q?frank=5Flupo?=" <frank_lupo@email.it> writes:
> If create a table and alter column add sequence. The relation on table and =
> sequence is not present in pg_depend.

What are you doing, exactly?  ADD COLUMN foo SERIAL doesn't work yet.

regression=# alter table vv add column f2 serial;
NOTICE:  ALTER TABLE will create implicit sequence 'vv_f2_seq' for SERIAL column 'vv.f2'
ERROR:  Adding columns with defaults is not implemented.
        Add the column, then use ALTER TABLE SET DEFAULT.

SET DEFAULT nextval('foo') does not create an auto-drop dependency,
and should not IMHO.

            regards, tom lane

pgsql-general by date:

Previous
From: "Greg Sabino Mullane"
Date:
Subject: Searchable 7.3.1 Documentation - now interactive!
Next
From: Tom Lane
Date:
Subject: Re: weird lower() problem with character