From: | David Hartwig <daveh(at)insightdist(dot)com> |
---|---|
To: | pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org>, "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
Subject: | Serial Data Type Failure |
Date: | 1998-09-18 17:55:25 |
Message-ID: | 36029E8D.E333FA31@insightdist.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Tom,
The following came from the most recient snapshot. I know your away
for a few days. I will give it a look-see if I get time this weekend
CREATE TABLE foo (
id serial primary key,
name varchar(32)
);
NOTICE: CREATE TABLE will create implicit sequence foo_id_seq for
SERIAL column foo.id
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index foo_pkey
for table foo
CREATE
-- This is good. Thanks.
CREATE TABLE bar (
id serial,
name varchar(32)
);
NOTICE: CREATE TABLE will create implicit sequence bar_id_key for
SERIAL column bar.id
NOTICE: CREATE TABLE/UNIQUE will create implicit index bar_id_key for
table bar
ERROR: Cannot create index: 'bar_id_key' already exists
-- This is bad. Sorry.
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Oliver | 1998-09-18 18:01:25 | [sferac@bo.nettuno.it: Re: [HACKERS] BUG: NOT boolfield kills backend] |
Previous Message | Bruce Momjian | 1998-09-18 17:19:35 | Re: [HACKERS] Compiling 6.4 on NetBSD-current/pc532 |