bug with serial field?

My table 'clientes' has a serial field,
with name 'rid'.
Now, take a look at these queries:

ss => select rid from clientes where rid > 18974 and
rid < 18976;
rid
-----
18975
(1 row)

ss => select rid from clientes where rid = 18975;
rid
---
(0 rows)

A vacuum (or vacuum analyze) did not fix the
problem.
I only fixed this by droping and recreating
the (implicit) index for the sequence:

ss => drop index clientes_temp_rid_key;
ss => CREATE UNIQUE INDEX "clientes_temp_rid_key" on
"clientes" using btree ( "rid" "int4_ops" );

And now, it's ok:

ss => select rid from clientes where rid = 18975;
rid
-----
18975
(1 row)

Rather disturbing, isn't it? Any ideas ?

Hernan Gonzalez
Buenos Aires, Argentina

__________________________________________________
Do You Yahoo!?
Talk to your friends online with Yahoo! Messenger.
http://im.yahoo.com