From: Hernan J. Gonzalez <leonbloy@yahoo.com>
To: pgsql-admin@postgreSQL.org
Subject: bug with serial field?
Date: Wed, 23 Feb 2000 13:01:30 -0800 (PST)
Message-ID: <20000223210130.28055.qmail@web206.mail.yahoo.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: leonbloy@yahoo.com
Subject: Re: bug with serial field?
In-Reply-To: <20000223210130.28055.qmail@web206.mail.yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox