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.