Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M269012=pgsql-hackers-arkari@postgresql.org>)
 id 1YTM0b-0002Iw-3g
 for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Mar 2015 02:59:33 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-hackers-owner+M269012=pgsql-hackers-arkari@postgresql.org>)
 id 1YTM0a-0002hj-37
 for pgsql-hackers@arkaria.postgresql.org; Thu, 05 Mar 2015 02:59:32 +0000
Received: from makus.postgresql.org ([2001:4800:1501:1::229])
 by malur.postgresql.org with esmtps (TLS1.2:DHE_RSA_AES_256_CBC_SHA256:256)
 (Exim 4.80) (envelope-from <peter_e@gmx.net>) id 1YTM0Z-0002hd-4M
 for pgsql-hackers@postgresql.org; Thu, 05 Mar 2015 02:59:31 +0000
Received: from mout.gmx.net ([212.227.17.21])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <peter_e@gmx.net>) id 1YTM0W-0000fj-0j
 for pgsql-hackers@postgresql.org; Thu, 05 Mar 2015 02:59:29 +0000
Received: from auth1-smtp.messagingengine.com ([66.111.4.227]) by mail.gmx.com
 (mrgmx101) with ESMTPSA (Nemesis) id 0Lkjuq-1Xsuj3342G-00aTNJ for
 <pgsql-hackers@postgresql.org>; Thu, 05 Mar 2015 03:59:25 +0100
Received: from compute2.internal (compute2.nyi.internal [10.202.2.42])
 by mailauth.nyi.internal (Postfix) with ESMTP id 39B4D20A4A
 for <pgsql-hackers@postgresql.org>; Wed,  4 Mar 2015 21:59:23 -0500 (EST)
Received: from frontend1 ([10.202.2.160])
 by compute2.internal (MEProxy); Wed, 04 Mar 2015 21:59:24 -0500
X-Sasl-enc: YH7Zab2s8duc1Q1WuqVP0EWNeGi1Zp2rNh9eIafPT/HL 1425524364
Received: from [10.0.0.13] (unknown [67.165.24.246])
 by mail.messagingengine.com (Postfix) with ESMTPA id 0041AC0029D;
 Wed,  4 Mar 2015 21:59:23 -0500 (EST)
Message-ID: <54F7C68B.9060609@gmx.net>
Date: Wed, 04 Mar 2015 21:59:23 -0500
From: Peter Eisentraut <peter_e@gmx.net>
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.10;
 rv:31.0) Gecko/20100101 Thunderbird/31.4.0
MIME-Version: 1.0
To: Stephen Frost <sfrost@snowman.net>
CC: Adam Brightwell <adam.brightwell@crunchydatasolutions.com>,
 Noah Misch <noah@leadboat.com>, Tom Lane <tgl@sss.pgh.pa.us>,
 PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: CATUPDATE confusion?
References: <28382.1419703324@sss.pgh.pa.us>
 <20141227231829.GX3062@tamriel.snowman.net> <1952.1419722762@sss.pgh.pa.us>
 <20141227233150.GA2046947@tornado.leadboat.com>
 <CAKRt6CTrOf6w5sE5GDRQAJ+JQrfK4h8VM=jVCtiGC+mdFsmXGg@mail.gmail.com>
 <54E65000.8030304@gmx.net> <20150225203955.GY29780@tamriel.snowman.net>
 <54EE8C6E.8090506@gmx.net> <20150226030541.GG29780@tamriel.snowman.net>
 <54F2376E.9080501@gmx.net> <20150228233245.GO29780@tamriel.snowman.net>
 <54F6286B.90802@gmx.net>
In-Reply-To: <54F6286B.90802@gmx.net>
Content-Type: text/plain; charset=windows-1252
Content-Transfer-Encoding: 7bit
X-Provags-ID: V03:K0:8ABaJOjHZR1S4NBuz3kpX7Z5dtqjpelCvJQwi9myZdpZ75TxPFK
 Tru//fbQ6TCae6A7C3gkj+FeWsEG733p4tok9gSUFE1FZ/TiQvtEi0HRNF3oxTUn4ym5w39
 SncTFqONGmnyeLfmvikmCkMGBdBoI1ppySXmw5ZqRx0nhJ6fcOEqnArw0fRFKDwUulabA/+
 PUJIrvaz9GBQwP0QuwaOQ==
X-UI-Out-Filterresults: notjunk:1;
X-Pg-Spam-Score: -1.9 (-)
List-Archive: <http://archives.postgresql.org/pgsql-hackers>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-hackers.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@postgresql.org>
List-Post: <mailto:pgsql-hackers@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-hackers>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
X-Mailing-List: pgsql-hackers
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

Any other opinions?

The options are:

0) Leave as is.

1) Remove catupdate and replace with superuser checks.

2) Remove catupdate and rely on regular table permissions on catalogs.



-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers