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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026