Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id BC17A9FB59C for ; Mon, 16 Jul 2007 15:48:56 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 84557-07 for ; Mon, 16 Jul 2007 15:48:41 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from main2.mycybernet.net (main2.mycybernet.net [209.222.63.140]) by postgresql.org (Postfix) with ESMTP id 7D3F09FB3D8 for ; Mon, 16 Jul 2007 15:48:53 -0300 (ADT) Received: from 227-54-222-209.mycybernet.net ([209.222.54.227] helo=phlogiston.dydns.org) by main2.mycybernet.net with esmtp (Exim 4.62) (envelope-from ) id 1IAVcg-0007iS-Bi for pgsql-admin@postgresql.org; Mon, 16 Jul 2007 14:48:42 -0400 Received: by phlogiston.dydns.org (Postfix, from userid 1000) id 102F03F9E; Mon, 16 Jul 2007 14:48:37 -0400 (EDT) Date: Mon, 16 Jul 2007 14:48:37 -0400 From: Andrew Sullivan To: pgsql-admin@postgresql.org Subject: Re: cache problem (v2) Message-ID: <20070716184837.GB18049@phlogiston.dyndns.org> References: <469B4927.9030604@eurofer.be> <20070716170957.GV18049@phlogiston.dyndns.org> <469BAF1D.8030108@eurofer.be> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <469BAF1D.8030108@eurofer.be> User-Agent: Mutt/1.5.9i X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/159 X-Sequence-Number: 26140 On Mon, Jul 16, 2007 at 07:47:09PM +0200, De Leeuw Guy wrote: > > > > 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 This is also opaque to me now, because that doesn't seem to be what your example said. Perhaps you should post your function body? > > 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 Well, that's not what your example said either. You need to show us actually what you are doing, rather than describing it in terms that leave out significant parts. > Yes I test this situation on my trigger. > I sure about 99% that my problem come from the cache. There is nothing in the cache that isn't "in the database", as it were, but there are visibility rules that might be affecting you. A -- Andrew Sullivan | ajs@crankycanuck.ca When my information changes, I alter my conclusions. What do you do sir? --attr. John Maynard Keynes