Postgres Pro
Downloads
Home   >   mailing lists

DROPping tables with SERIALs - Mailing list pgsql-hackers

From Jan Iven
Subject DROPping tables with SERIALs
Date
Msg-id 199811271520.QAA00697@pollux.rz.uni-sb.de
Whole thread Raw
Responses Re: [HACKERS] DROPping tables with SERIALs  (jwieck@debis.com (Jan Wieck))
Re: [HACKERS] DROPping tables with SERIALs  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
Tree view 
Hi,

I have run into a problem dropping and re-creating tables with
type SERIAL:

CREATE TABLE t ( s SERIAL);
DROP TABLE t;
CREATE TABLE t ( s SERIAL);

gives
ERROR:  t_s_seq relation already exists

This looks like the implicitly created sequence t_s_seq is not dropped
together with the table.

I am running a current (?) cvs snapshot from anoncvs@postgresql.org.

Jan

pgsql-hackers by date:

Previous
From: Sferacarta Software
Date:
Subject: copy
Next
From: Gilmar Ribeiro da Rosa
Date:
Subject: ...