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

BUG #2210: an update query bug with a table but not with your backup

From: "Ricardo Solanilla" <abasoft(at)ciudad(dot)com(dot)ar>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2210: an update query bug with a table but not with your backup
Date: 2006-01-25 19:44:52
Message-ID: 20060125194452.31016F0A2F@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2210
Logged by:          Ricardo Solanilla
Email address:      abasoft(at)ciudad(dot)com(dot)ar
PostgreSQL version: 8.0
Operating system:   Windows XP
Description:        an update query bug with a table but not with your
backup
Details: 

i try those querys, they are too similars and simple.. but the first work
fine but the second don't. Then i do a backup with insert clauses and put
both tables in another empty database, but now work fine the second query
too. it's depending on data i think, but i've done a backup and  it have the
same number of rows..
If you like to study that i can send you the entire backup of database.

I'm system engenieer and hope i know that i know !! :-)

Tia.


update ctem set idctb = (SELECT CreConcep.DeudaIdctb from creconcep INNER
JOIN CTEM C1 ON 
(c1.codcreconcep = creconcep.cod) WHERE C1.ID = CTEM.ID)
where ctem.tipovalt = 'CC-M' and CodCreConcep is not null

update ctem set idctb = (SELECT CreConcep.DeudaADevIdctb from creconcep
INNER JOIN CTEM C1 ON 
(c1.codcreconcep = creconcep.cod) WHERE C1.ID = CTEM.ID)
where ctem.tipovalt = 'CC-A' and CodCreConcep is not null

pgsql-bugs by date

Next:From: Michael FuhrDate: 2006-01-25 21:59:54
Subject: Re: BUG #2208: Low performance on select
Previous:From: Fahri CAKIROGLUDate: 2006-01-25 13:28:18
Subject: BUG #2209: Low performan on consecutive selects

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