Received: from localhost (maia-4.hub.org [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 1A29D9FB92C for ; Mon, 16 Jul 2007 14:47:41 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 65521-09 for ; Mon, 16 Jul 2007 14:47:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from BRUBLUmx12.mactelecom.net (BRUBLUmx12.mactelecom.net [217.64.240.4]) by postgresql.org (Postfix) with ESMTP id E4ACA9FB81B for ; Mon, 16 Jul 2007 14:47:37 -0300 (ADT) Received: from smtp.eurofer.be (217.64.254.218.mactelecom.net [217.64.254.218]) by BRUBLUmx12.mactelecom.net (Postfix) with ESMTP id E77EA838067; Mon, 16 Jul 2007 19:47:26 +0200 (CEST) Received: from ip-80-236-202-236.dsl.scarlet.be ([80.236.202.236] helo=[192.168.1.105]) by smtp.eurofer.be with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.63) (envelope-from ) id 1IAUf8-0001vv-Ea; Mon, 16 Jul 2007 19:47:26 +0200 Message-ID: <469BAF1D.8030108@eurofer.be> Date: Mon, 16 Jul 2007 19:47:09 +0200 From: De Leeuw Guy User-Agent: IceDove 1.5.0.10 (X11/20070329) MIME-Version: 1.0 To: Andrew Sullivan CC: pgsql-admin@postgresql.org References: <469B4927.9030604@eurofer.be> <20070716170957.GV18049@phlogiston.dyndns.org> In-Reply-To: <20070716170957.GV18049@phlogiston.dyndns.org> X-Enigmail-Version: 0.94.2.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Spam_score: -3.9 X-SA-Exim-Connect-IP: 80.236.202.236 X-SA-Exim-Mail-From: G.De_Leeuw@eurofer.be Subject: Re: cache problem (v2) X-SA-Exim-Scanned: Yes (on smtp.eurofer.be) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/158 X-Sequence-Number: 26139 Hello Andrew, Thanks for your attention Andrew Sullivan a écrit : > I tried to answer the previous version of this mail, but I don't > understand it. Let me see if my questions trigger something for you, > though. > > So if I am reading you correctly, IF code IN (1,2) THEN {do > something}? What do you do then? I don't get this part. > I record a row with code = 3 and the value = the sum of each values in code 1 & 2 > I don't see how this is possible either. You just deleted from test; > how can you hae anything left in there? > I skip the delete action when the code is a sum code > >> maybe this is because these commands start a transaction with a cache >> and each time that I request a select for a sum code that are on the >> cache the value returned are not the real new value. >> > > No, but a trigger that executes SQL can cause the trigger to fire > again. Are you sure that's not happening? > > Yes I test this situation on my trigger. I sure about 99% that my problem come from the cache. Regards Guy