Skip site navigation (1) Skip section navigation (2)

serial type

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 (view raw or flat)
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'

Responses

pgsql-hackers by date

Next:From: Jose' SoaresDate: 1998-10-28 13:49:21
Subject: lock table
Previous:From: TeknSOFT S.n.c.Date: 1998-10-28 12:31:03
Subject: SCO 5.0.x binaries ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group