postgresql sequence nextval in schema

Question

I have a sequence on postgresql 9.3 inside a schema.

I can do this:

SELECT last_value, increment_by from foo."SQ_ID";` 

last_value | increment_by ------------+--------------           1 |            1 (1 fila) 

But this doesn't work:

SELECT nextval('foo.SQ_ID'); 

ERROR:  no existe la relación «foo.sq_id» LÍNEA 1: SELECT nextval('foo.SQ_ID'); 

What is wrong ?

It says that not exist the relation foo.sq_id, but it exists.

Answer 1

The quoting rules are painful. I think you want:

SELECT nextval('foo."SQ_ID"'); 

to prevent case-folding of SQ_ID.