Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 936E39FB1F8 for ; Wed, 21 Mar 2007 12:44:06 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-new, port 10024) with ESMTP id 70782-02 for ; Wed, 21 Mar 2007 12:43:57 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from eastrmmtao103.cox.net (eastrmmtao103.cox.net [68.230.240.9]) by postgresql.org (Postfix) with ESMTP id CBAF29FB1D3 for ; Wed, 21 Mar 2007 12:43:57 -0300 (ADT) Received: from eastrmimpo02.cox.net ([68.1.16.120]) by eastrmmtao103.cox.net (InterMail vM.7.05.02.00 201-2174-114-20060621) with ESMTP id <20070321154357.TAL3661.eastrmmtao103.cox.net@eastrmimpo02.cox.net> for ; Wed, 21 Mar 2007 11:43:57 -0400 Received: from haggis.homelan ([70.171.104.122]) by eastrmimpo02.cox.net with bizsmtp id dTjw1W0012eTmf20000000; Wed, 21 Mar 2007 11:43:56 -0400 Received: by haggis.homelan (Postfix, from userid 1002) id 0ECB4240A2B; Wed, 21 Mar 2007 10:43:56 -0500 (CDT) Received: from [192.168.1.10] (haggis.homelan [192.168.1.10]) by haggis.homelan (Postfix) with ESMTP id 51682240A1D for ; Wed, 21 Mar 2007 10:43:45 -0500 (CDT) Message-ID: <460152B1.8040101@cox.net> Date: Wed, 21 Mar 2007 10:43:45 -0500 From: Ron Johnson User-Agent: Icedove 1.5.0.10 (X11/20070307) MIME-Version: 1.0 To: pgsql-general@postgresql.org Subject: Re: Anyone still using the sql_inheritance parameter? References: <28097.1174488581@sss.pgh.pa.us> In-Reply-To: <28097.1174488581@sss.pgh.pa.us> X-Enigmail-Version: 0.94.2.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.058 tagged_above=0 required=5 tests=AWL, BAYES_20, FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200703/1230 X-Sequence-Number: 111419 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 03/21/07 09:49, Tom Lane wrote: > Is anybody still using the ability to set sql_inheritance to OFF? > I'm considering removing the parameter in PG 8.3, so that the current > default behavior (sql_inheritance = ON) would be the only behavior. > sql_inheritance was created in 7.1 to allow existing applications to > not be broken when we changed the default behavior, but I have not > heard of anyone using it recently. > [snip] > > So: would anyone cry if sql_inheritance disappeared in 8.3? > > If there are a lot of complaints, a possible compromise is to keep the > variable but make it SUSET, ie, only changeable by superusers. This > would still allow the setting to be turned off for use by legacy > applications (probably by means of ALTER USER) while removing the > objection that non-privileged users could break things. Shouldn't features be deprecated for a version before removal? -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) iD8DBQFGAVKxS9HxQb37XmcRAmTbAKDfcRX1zP5NWqVjiiAb/p5KL8vdPACePdip HCIWBGMMbZVkUuO92h+fOos= =sVjt -----END PGP SIGNATURE-----