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