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