[GENERAL] serial type - Mailing list pgsql-general

I'm trying to create a table as such:

create table comment
(rec_id serial,
locale varchar(50),
...)

It creates correctly, telling me that it will create an implicit sequence
for the serial column, and an implicit index for the table.  But, when I
try to insert a record into the database (without specifying the value for
the rec_id column) I get the following error:

ERROR:  serial.nextval: sequence does not exist

Does anyone have any ideas (I'm not sure whether this belongs on this
list, or the pgsql-sql list)?

Thanks, Greg.

Greg Beams - gob@students.cs.mu.oz.au

I'M NOT OKAY, YOU'RE NOT OKAY--BUT, HEY, THAT'S OKAY.