Re: NEXTVAL function Bug

"Dan Wilson"  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