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