pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Andrew Sullivan <ajs@crankycanuck.ca>
To: pgsql-admin@postgresql.org
Subject: Re: cache problem (v2)
Date: Mon, 16 Jul 2007 14:48:37 -0400
Message-ID: <20070716184837.GB18049@phlogiston.dyndns.org> (raw)
In-Reply-To: <469BAF1D.8030108@eurofer.be>
References: <469B4927.9030604@eurofer.be>
	<20070716170957.GV18049@phlogiston.dyndns.org>
	<469BAF1D.8030108@eurofer.be>

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



view thread (14+ messages)  latest in thread

Message-ID: <20070716184837.GB18049@phlogiston.dyndns.org>
Permalink:  ../20070716184837.GB18049@phlogiston.dyndns.org/
Also on:    postgresql.org/message-id/20070716184837.GB18049@phlogiston.dyndns.org

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: ajs@crankycanuck.ca
  Subject: Re: cache problem (v2)
  In-Reply-To: <20070716184837.GB18049@phlogiston.dyndns.org>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox