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

Browse pgsql-bugs by date

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