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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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