X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 072CED1B50F for ; Sat, 20 Sep 2003 22:38:37 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 41965-06 for ; Sat, 20 Sep 2003 19:38:26 -0300 (ADT) Received: from ohsmtp02.ogw.rr.com (ohsmtp02.ogw.rr.com [65.24.7.37]) by svr1.postgresql.org (Postfix) with ESMTP id E0C04D1B509 for ; Sat, 20 Sep 2003 19:38:25 -0300 (ADT) Received: from corvette.mascari.com (uar225045.columbus.rr.com [204.210.225.45]) by ohsmtp02.ogw.rr.com (8.12.5/8.12.2) with ESMTP id h8KMcP2s015779; Sat, 20 Sep 2003 18:38:25 -0400 (EDT) Received: from mascari.com (ferrari.mascari.com [192.168.2.1]) by corvette.mascari.com (8.11.6/8.11.6) with ESMTP id h8KMbpM26833; Sat, 20 Sep 2003 18:37:51 -0400 Message-ID: <3F6CD6BF.5030206@mascari.com> Date: Sat, 20 Sep 2003 18:37:51 -0400 From: Mike Mascari User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:1.4) Gecko/20030624 X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: Richard Huxton , Lista dyskusyjna pgsql-general Subject: Re: PG + PHP, was Re: Zend survey result about dbms... References: <000501c37e9e$0ecffc70$4701a8c0@marek> <20022.1063984707@sss.pgh.pa.us> <200309201248.54484.dev@archonet.com> <23474.1064069400@sss.pgh.pa.us> <3F6CD248.8040006@mascari.com> <29970.1064096941@sss.pgh.pa.us> In-Reply-To: <29970.1064096941@sss.pgh.pa.us> X-Enigmail-Version: 0.74.1.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-MailScanner: Found to be clean X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/1398 X-Sequence-Number: 49617 Tom Lane wrote: > Mike Mascari writes: > >>In the past, one hack would be to use setenv() and getenv() of the >>backend to implement these functions. What about a contrib module that: > > > Uh, what exactly does it buy you to involve an environment variable > in this process? I think it just adds fragility. (For example, > exposing setenv to the user creates the risk that he'll overwrite > something of importance, like PATH.) Actually, I meant that setenv() and getenv() would only be used to store the memory address of a privately manipulated variable map. I did not mean that it should actually be used to store and retrieve the variables themselves. If there is already a way to palloc() memory using a key that lives for the lifetime of a backend, then that's obviously the way to go. I was proceeding under the assumption that there wasn't. Mike Mascari mascarm@mascari.com