Re: [GENERAL] NEXTVAL function Bug

[Tom Lane]

"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 only a historical artifact that nextval wants a quoted name
at all.  The syntax should have been something like nextval(seqname) or
seqname.nextval, with no string literal.

                        regards, tom lane