Re: drop table problem

"=?utf-8?Q?frank=5Flupo?=" <frank_lupo(at)email(dot)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