X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (mx2.hub.org [200.46.204.254]) by postgresql.org (Postfix) with ESMTP id 94C5711F6753 for ; Wed, 12 Apr 2006 20:05:17 -0300 (ADT) X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Score: -2.425 X-Spam-Level: X-Spam-Status: No, score=-2.425 required=5 tests=[AWL=0.174, BAYES_00=-2.599] Received: from postgresql.org ([200.46.204.71]) by localhost (mx2.hub.org [200.46.204.254]) (amavisd-new, port 10024) with ESMTP id Ktn8TwpmUBsx for ; Wed, 12 Apr 2006 20:05:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from davinci.ethosmedia.com (server227.ethosmedia.com [209.128.84.227]) by postgresql.org (Postfix) with ESMTP id E432011F607B for ; Wed, 12 Apr 2006 20:05:08 -0300 (ADT) X-EthosMedia-Virus-Scanned: no infections found Received: from [64.81.245.111] (account josh@agliodbs.com HELO [192.168.1.27]) by davinci.ethosmedia.com (CommuniGate Pro SMTP 4.1.8) with ESMTP id 9253969; Wed, 12 Apr 2006 16:08:10 -0700 From: Josh Berkus Reply-To: josh@agliodbs.com Organization: Aglio Database Solutions To: pgsql-performance@postgresql.org Subject: Re: pgmemcache Date: Wed, 12 Apr 2006 16:03:43 -0700 User-Agent: KMail/1.8 Cc: PFC , "Jim C. Nasby" , "C Storm" References: <1144135482.063425.33380@z34g2000cwc.googlegroups.com> <20060411225515.GZ49405@pervasive.com> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200604121603.43986.josh@agliodbs.com> X-Archive-Number: 200604/278 X-Sequence-Number: 18362 PFC, > It would be nice to have ON COMMIT triggers for this use. > > However you can emulate ON COMMIT triggers with a modification of the > memcache update process : Well, I'm back in touch with the GORDA project so possibly we can have BEFORE COMMIT triggers after all. BTW, it's important to note that AFTER COMMIT triggers are logically impossible, so please use BEFORE COMMIT so that it's clear what we're talking about. -- --Josh Josh Berkus PostgreSQL @ Sun San Francisco