DROPping tables with SERIALs

From: Jan Iven <j(dot)iven(at)rz(dot)uni-sb(dot)de>
To: pgsql-hackers(at)postgreSQL(dot)org
Subject: DROPping tables with SERIALs
Date: 1998-11-27 15:20:56
Message-ID: 199811271520.QAA00697@pollux.rz.uni-sb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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(at)postgresql(dot)org(dot)

Jan

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gilmar Ribeiro da Rosa 1998-11-27 15:29:56
Previous Message Sferacarta Software 1998-11-27 13:46:45 copy