Hi all,

I don't know if this was alredy reported, if so, please forget it.
I created a table with a serial data type and PostgreSQL creates an
implicit sequence, 
then I droped the table but the sequence is already there, if I try to
re-create 
the same table PostgreSQL refuse to do that...

prova=> create table a (i int, s smallint, c serial);
NOTICE:  CREATE TABLE will create implicit sequence a_c_seq for SERIAL
column a.c
NOTICE:  CREATE TABLE/UNIQUE will create implicit index a_c_key for
table a
CREATE
prova=> drop table a;
DROP
prova=> create table a (i int, s smallint, c serial);
NOTICE:  CREATE TABLE will create implicit sequence a_c_seq for SERIAL
column a.c
NOTICE:  CREATE TABLE/UNIQUE will create implicit index a_c_key for
table a
ERROR:  a_c_seq relation already exists

Jose'

Wed, 28 Oct 1998 14:27:27 +0100
"Jose' Soares" <jose@sferacarta.com>
serial type
> I don't know if this was alredy reported, if so, please forget it.
> I created a table with a serial data type and PostgreSQL creates an
> implicit sequence,
> then I droped the table but the sequence is already there, if I try to
> re-create
> the same table PostgreSQL refuse to do that...

Yes, it is a known feature for v6.4, and is in the docs (which doesn't
make it right, of course :)

Hopefully we will merge this with other improvements for v6.5 and get it
better then.

                - Tom

Wed, 28 Oct 1998 16:33:36 +0000
"Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
Re: [HACKERS] serial type