Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id 091F8B5DBCC for ; Tue, 16 Aug 2011 01:04:46 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 96024-07 for ; Tue, 16 Aug 2011 04:04:34 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from pd4.baremetal.com (pd4.baremetal.com [209.17.165.1]) by mail.postgresql.org (Postfix) with ESMTP id C259BB5DBBE for ; Tue, 16 Aug 2011 01:04:33 -0300 (ADT) Received: from Darren-Duncans-iMac.local (S0106000f66d65e51.gv.shawcable.net [96.54.45.173]) by pd4.baremetal.com (8.13.4/8.13.4) with ESMTP id p7G44UgE024628; Mon, 15 Aug 2011 21:04:30 -0700 Message-ID: <4E49EC4D.1090707@darrenduncan.net> Date: Mon, 15 Aug 2011 21:04:29 -0700 From: Darren Duncan User-Agent: Thunderbird 2.0.0.24 (Macintosh/20100228) MIME-Version: 1.0 To: Chris Travers CC: pgsql-general@postgresql.org Subject: Re: Using Postgresql as application server References: <4E498536.9080109@darrenduncan.net> <008301cc5b95$e287b120$a7971360$@yahoo.com> <4E49A208.5070604@darrenduncan.net> In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Scanned-By: MIMEDefang 2.36 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201108/471 X-Sequence-Number: 178753 Chris Travers wrote: > On Mon, Aug 15, 2011 at 3:47 PM, Darren Duncan wrote: >> I believe we basically have all the foundation already, with maybe >> procedures executable outside transactions being the last major part. >> > Why is this desirable? Why is it more desirable than actually using > the listen/notify infrastructure that exists already? Maybe listen/notify is sufficient by itself. I withdraw my "procedures executable outside transactions" comment for now, and just bring it up later if I can think of a specific use case that other mechanisms don't satisfy. -- Darren Duncan