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
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 |