Skip site navigation (1) Skip section navigation (2)

Re: strange update problem with 7.2.1

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>,Ivan Panchenko <ivan(at)xray(dot)sai(dot)msu(dot)ru>,Teodor Sigaev <teodor(at)stack(dot)net>
Subject: Re: strange update problem with 7.2.1
Date: 2002-05-25 15:58:52
Message-ID: 26091.1022342332@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> writes:
> test=# update tst set i = i+10   where a && '{3,4}';
> UPDATE 3267
> test=# set enable_indexscan=off;
> SET VARIABLE
> test=# update tst set i = i+10   where a && '{3,4}';
> UPDATE 4060

I get the same in current sources (in fact the number of rows updated
varies from try to try).  Are you sure it's not a problem with the
gist index mechanism?

			regards, tom lane

In response to

Responses

pgsql-hackers by date

Next:From: Oleg BartunovDate: 2002-05-25 17:06:57
Subject: Re: strange update problem with 7.2.1
Previous:From: Tom LaneDate: 2002-05-25 15:44:45
Subject: Re: Edge case problem with pg_dump

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group