"Dan Wilson" <[EMAIL PROTECTED]> writes:
> test_db=# insert into "mixed_Case" (mix_id, mix_var) values
> (nextval('mixed_Case_mix_id_seq'), 'not working');
> ERROR: Relation 'mixed_case_mix_id_seq' does not exist
You need to do it like this:
nextval('"mixed_Case_mix_id_seq"')
IMHO it's
Ok... I think I found a bug... tell me if I'm smoking something on this:
I create a table with a mixed case name... everything works fine until I try
to use the sequence created with the SERIAL datatype.
test_db=# create table "mixed_Case" ("mix_id" SERIAL, "mix_var"
varchar(50));
NOTICE: CREAT
