Re: A problem with sequences...

I got it!

For those, who are still wonderring, the actual problem had nothing to do with that rule.

I was loading some stuff into the database through a sql script (copy from etc...), and in the end of it I did:

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!
Here is an example:

rapidb=# select max(id) from answer;
max
-------
25000
(1 row)

rapidb=# select last_value from answer_id_seq;
last_value
------------
22124
(1 row)

rapidb=# select setval ('answer_id_seq', id) from answer order by id desc limit 1;
setval
--------
25000
(1 row)

rapidb=# select currval('answer_id_seq');
currval
---------
21452
(1 row)

So, the question I have now is - what's going on?
How come setval() reports 25000, but the currval changes to 21452
If my query is wrong (and I can't really see what's wrong with it), then why does it report the correct value?

I have rewritten that script to do
select setval ('answer_id_seq', max(id)) from answer
instead, and that works fine... But I'd still love to find out what is wrong with that original query's behaviour...

Thanks!

Dima