Hi everyone,
Hi everyone,
I need help to set a sequence value.
I use the following query to list sequences in the database and it works returning the list of available sequences on the database.
SELECT sequence_schema, sequence_name
FROM information_schema.sequences
ORDER BY sequence_name;
However the query to set the next value on the sequence:
SELECT setval('Actuacion_id_seq', 12345, true);
...fails with the following error:
ERROR: relation "actuacion_id_seq" does not exist (SQLSTATE 42P01)
Can you help me with the correct query to set the next sequence value?
I need help to set a sequence value.
I use the following query to list sequences in the database and it works returning the list of available sequences on the database.
SELECT sequence_schema, sequence_name
FROM information_schema.sequences
ORDER BY sequence_name;
However the query to set the next value on the sequence:
SELECT setval('Actuacion_id_seq', 12345, true);
...fails with the following error:
ERROR: relation "actuacion_id_seq" does not exist (SQLSTATE 42P01)
Can you help me with the correct query to set the next sequence value?
