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

Re: Serial Data Type Failure

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: David Hartwig <daveh(at)insightdist(dot)com>
Cc: pgsql-hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: Serial Data Type Failure
Date: 1998-09-21 00:50:13
Message-ID: 3605A2C5.83A2F2C7@alumni.caltech.edu (view raw, whole thread or download thread mbox)
Thread:
Lists: pgsql-hackers
> The following came from the most recient snapshot.
> 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.

OK, will look at it if you haven't fixed it already...

                     - Tom

In response to

Responses

pgsql-hackers by date

Next:From: Christopher OliverDate: 1998-09-21 00:54:00
Subject: Re: [sferac@bo.nettuno.it: Re: [HACKERS] BUG: NOT boolfield kills backend]
Previous:From: Thomas G. LockhartDate: 1998-09-21 00:26:05
Subject: Re: [HACKERS] Windows NT port of Postgres

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