Re: [HACKERS] BUG? serials and primary keys (was Re: [INTERFACES] Bug in psql?)

> test=> create table "TestTable" ("Field" serial primary key, some text);
> NOTICE:  CREATE TABLE will create implicit sequence TestTable_Field_seq
> for SERIAL column TestTable.Field
> NOTICE:  CREATE TABLE/PRIMARY KEY will create implicit index
> TestTable_pkey for table TestTable
> CREATE
> test=> insert into "TestTable" (some) values ('test text');
> ERROR:  testtable_field_seq.nextval: sequence does not exist
> test=> \ds
> 
> Database    = test
>  +------------------+----------------------------------+----------+
>  |  Owner           |             Relation             |   Type   |
>  +------------------+----------------------------------+----------+
>  | reedstrm         | TestTable_Field_seq              | sequence |
>  +------------------+----------------------------------+----------+
> test=> 
> 
> Anybody test this on 6.5? 

We are working on a fix for the case thing right now.

--  Bruce Momjian                        |  http://www.op.net/~candle maillist@candle.pha.pa.us            |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026