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.
The quoting rules are painful. I think you want:
SELECT nextval('foo."SQ_ID"');
to prevent case-folding of SQ_ID
.