What s wrong with the syntax of this SQL query?

Question

SELECT setval(pg_get_serial_sequence(‘tags’, ‘id’), SELECT max(id) FROM tags);

Using PostgreSQL inside rails. I am trying to correct it to execute inActiveRecords. I am not an expert in SQL. How would you correct it please ? — codigomonstruo, Aug 13 '16 at 01:29
Moussa, @sgeddes, have already provided the answer to you by linking the other similar post. Go through it and change your query accordingly — Rahul, Aug 13 '16 at 01:35
Possible duplicate of [How to reset postgres' primary key sequence when it falls out of sync?](http://stackoverflow.com/questions/244243/how-to-reset-postgres-primary-key-sequence-when-it-falls-out-of-sync) — Will, Aug 13 '16 at 02:21

score 2 · Accepted Answer · answered Aug 13 '16 at 03:48

2

You are using curly quotes ‘’ while you should be using straight quotes '':

SELECT setval(pg_get_serial_sequence('tags', 'id'), SELECT max(id) FROM tags);

answered Aug 13 '16 at 03:48

Patrick

score 1 · Answer 2 · answered Aug 13 '16 at 11:29

1

I think this is the code you intend:

SELECT setval(pg_get_serial_sequence('tags', 'id'), maxid)
FROM ( SELECT max(id) as maxid FROM tags) t;

answered Aug 13 '16 at 11:29

Gordon Linoff

2 Answers2