From: | "Jose' Soares" <jose(at)sferacarta(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | serial type |
Date: | 1998-10-28 13:27:27 |
Message-ID: | 36371BBF.B33D8A75@sferacarta.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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'
From | Date | Subject | |
---|---|---|---|
Next Message | Jose' Soares | 1998-10-28 13:49:21 | lock table |
Previous Message | TeknSOFT S.n.c. | 1998-10-28 12:31:03 | SCO 5.0.x binaries ? |