> 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