Re: drop table problem

From: frank_lupo <frank_lupo(at)email(dot)it>
To: tgl <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: drop table problem
Date: 2003-01-25 13:35:09
Message-ID: H99V2M$A5659A108EA0B342BC5627E76622DA8F@email.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> "=?utf-8?Q?frank=5Flupo?=" 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
>

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---

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tilo Schwarz 2003-01-25 15:57:14 Re: Is there a way knowing which database I'm connecting to?
Previous Message frank_lupo 2003-01-25 13:29:20 Re: drop table problem