From: | Tom Innes <tinnes(at)inforamp(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Use of Serial Datatype and Sequence Issue |
Date: | 2001-11-02 00:28:18 |
Message-ID: | 3BE1EACF.CA948459@inforamp.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers pgsql-general |
I am new to postgres and am in the process of creating a new database of
several 100 tables. Most of the tables have a serial datatype. When the
table is created psql says it is creating an implicit sequence. Yet
when I drop the table and even when I drop the database the sequence is
still there. When I try to re-create the table it fails beacuse the
sequence already exists. This same behaviour exists for indexes. How
can I get rid of any sequences or indexes that have been created. I
would prefer not to explicitly drop each one. Ideally I would like to
drop the table and have all related indexes, sequences dropped.
Tom
From | Date | Subject | |
---|---|---|---|
Next Message | Jean-Michel POURE | 2001-11-03 11:18:49 | Re: New Graphics |
Previous Message | Dave Page | 2001-11-01 09:17:45 | New Graphics |
From | Date | Subject | |
---|---|---|---|
Next Message | Johnson, Shaunn | 2001-11-02 01:17:16 | SQL question |
Previous Message | Joseph Shraibman | 2001-11-01 23:55:49 | Bruce's book is not mirrored |