The following bug has been logged online:

Bug reference: 2219
Logged by: Ricardo Solanilla
Email address: abasoft (AT) ciudad (DOT) 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.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend