Re: drop table problem - Mailing list pgsql-general

From frank_lupo
Subject Re: drop table problem
Date
Msg-id H99V2M$A5659A108EA0B342BC5627E76622DA8F@email.it
Whole thread Raw
Responses Re: Re: drop table problem
List pgsql-general
> "frank_lupo"  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 implemente d.
0D
>         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
 
An other problem and that if I create a table p1 with a field sequence and this sequence I associate it to one other table p2, when drop p1 the table p2 remains without sequence.
 
Tanks
 
Bye !! Frank Lupo (Wolf) !! /\_ _/\ \ o o / --ooo-----ooo---

pgsql-general by date:

Previous
From: "frank_lupo"
Date:
Subject: Re: drop table problem
Next
From: =?iso-8859-9 ?q?=C7a=F0=FDl=20=DEeker?=
Date:
Subject: pcap filter for postgresql authorization