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

BUG #2219: bug in 12000 rows update

From: "Ricardo Solanilla" <abasoft(at)ciudad(dot)com(dot)ar>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2219: bug in 12000 rows update
Date: 2006-01-27 23:01:02
Message-ID: 20060127230102.DA1ACF0ACA@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2219
Logged by:          Ricardo Solanilla
Email address:      abasoft(at)ciudad(dot)com(dot)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

Next:From: Peter EisentrautDate: 2006-01-28 19:17:17
Subject: Re: Bug#347548: DOMAIN CHECK constraint bypassed
Previous:From: NicholasDate: 2006-01-27 18:12:50
Subject: BUG #2218: Variables selected in VIEWs under different names break queries using those views

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