Re: A problem with sequences...

Dmitry Tkach <dmitry@openratings.com> writes:

> select setval('answer_id_seq', id) from answer order by id desc limit 1;
>
> Now, for some reason this reports a correct value, but what actually
> gets set is wrong!

I'm guessing that 'setval' is getting called more than once here.
Your 'LIMIT 1' controls how many rows are returned to the client, but
the server is probably generating more rows internally.  So this is
just wrong, and

> select setval ('answer_id_seq', max(id)) from answer

is right.

-Doug