"Dan Wilson" <phpPgAdmin(at)acucore(dot)com> 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