BUG #2219: bug in 12000 rows update - Mailing list pgsql-bugs

From Ricardo Solanilla
Subject BUG #2219: bug in 12000 rows update
Date
Msg-id 20060127230102.DA1ACF0ACA@svr2.postgresql.org
Whole thread Raw
List pgsql-bugs
The following bug has been logged online:

Bug reference:      2219
Logged by:          Ricardo Solanilla
Email address:      abasoft@ciudad.com.ar
PostgreSQL version: 8.0
Operating system:   Windows XP
Description:        bug in 12000 rows update
Details:

i has report this bug earlier (ref. 2210) but i've news. The problem
dissapear if i execute the update query with less rows ..
begin transaction;
... where id > 100 and id <= 1000
commit;

begin transaction;
... where id > 1001 .. and so
commit;

and i've noted that without begin transaction and commit the group of querys
doesn't work (in pgadmin iii).

the problem is in a specific database, then i only can offer send my
database to anybody who like it, i cannot make a case to show the bug.

pgsql-bugs by date:

Previous
From: "Nicholas"
Date:
Subject: BUG #2218: Variables selected in VIEWs under different names break queries using those views
Next
From: Tom Lane
Date:
Subject: Re: BUG #2218: Variables selected in VIEWs under different names break queries using those views