postgresql sequence nextval in schema
postgresql, postgresql-9.3
Solution
The quoting rules are painful. I think you want:
SELECT nextval('foo."SQ_ID"');
to prevent case-folding of `SQ_ID`.
Problem
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.