Thread: drop table problem

drop table problem

From
"frank_lupo"
Date:

I using 

PostgreSQL 7.3.1 on i686-pc-cygwin, compiled by GCC gcc (GCC) 3.2 20020927 (prerelease)

If create a table and alter column add sequence. The relation on table and sequence is not present in pg_depend.
When drop table the sequence is not dropped.

Bye !!
Frank Lupo (Wolf) !!
 
     /\_ _/\
      \ o o /
--ooo-----ooo---
 
 

----
Prendi GRATIS l'email universale che... risparmia: clicca qui

Sponsor:
La tua macchina si avvia tossendo? Trova un elettrauto su QxService
cliccando qui
Clicca qui

Re: drop table problem

From
Tom Lane
Date:
"=?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