Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 6B18F2E3004 for ; Tue, 18 Dec 2007 14:50:59 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 43801-07 for ; Tue, 18 Dec 2007 14:50:44 -0400 (AST) Received: from fhw-relay07.plus.net (fhw-relay07.plus.net [212.159.14.215]) by postgresql.org (Postfix) with ESMTP id 3E44F2E2F71 for ; Tue, 18 Dec 2007 14:50:55 -0400 (AST) Received: from [84.51.143.99] (helo=server3.office.archonet.com) by fhw-relay07.plus.net with esmtp (Exim) id 1J4hWY-0005z4-3G; Tue, 18 Dec 2007 18:50:38 +0000 Received: from [192.168.1.36] (dell36.office.archonet.com [192.168.1.36]) by server3.office.archonet.com (Postfix) with ESMTP id CFFEF27404E; Tue, 18 Dec 2007 18:50:36 +0000 (GMT) Message-ID: <4768167C.3040306@archonet.com> Date: Tue, 18 Dec 2007 18:50:36 +0000 From: Richard Huxton User-Agent: Thunderbird 2.0.0.9 (X11/20071031) MIME-Version: 1.0 To: "Roberts, Jon" CC: 'Alvaro Herrera' , 'Kris Jurka' , Merlin Moncure , "Jonah H. Harris" , Bill Moran , "Joshua D. Drake" , pgsql-performance@postgresql.org Subject: Re: viewing source code References: <1A6E6D554222284AB25ABE3229A92762112A25@nrtexcus702.int.asurion.com> In-Reply-To: <1A6E6D554222284AB25ABE3229A92762112A25@nrtexcus702.int.asurion.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/269 X-Sequence-Number: 28085 Roberts, Jon wrote: > So you are saying I need to create a view per user to achieve this? That > isn't practical for an enterprise level database. Surely you'd just have: CREATE VIEW ... AS SELECT * FROM pg_proc WHERE author=CURRENT_USER -- Richard Huxton Archonet Ltd