Re: 8.1 removed functions - Mailing list pgsql-general

From Michael Fuhr
Subject Re: 8.1 removed functions
Date
Msg-id 20060101155352.GA41439@winnie.fuhr.org
Whole thread Raw
In response to Re: 8.1 removed functions  (nielsgron@gmail.com)
List pgsql-general
On Wed, Dec 28, 2005 at 05:34:47PM -0800, nielsgron@gmail.com wrote:
> With PG 8.0 I was using a query using makeaclitem() and aclcontains()
> to extract permissions.  Here is a sample query for database
> permissions ...
[...]
> What is the recommended manner to extract object permissions for 8.1
> now that these functions are not available?

aclcontains is still there but makeaclitem's signature has changed:

8.0.5
test=> \df makeaclitem|aclcontains
                                   List of functions
   Schema   |    Name     | Result data type |           Argument data types
------------+-------------+------------------+------------------------------------------
 pg_catalog | aclcontains | boolean          | aclitem[], aclitem
 pg_catalog | makeaclitem | aclitem          | integer, integer, integer, text, boolean
(2 rows)

8.1.1
test=> \df makeaclitem|aclcontains
                           List of functions
   Schema   |    Name     | Result data type |   Argument data types
------------+-------------+------------------+-------------------------
 pg_catalog | aclcontains | boolean          | aclitem[], aclitem
 pg_catalog | makeaclitem | aclitem          | oid, oid, text, boolean
(2 rows)

For examples look at standard views that use makeaclitem:

SELECT * FROM pg_views WHERE definition ~* 'makeaclitem';

--
Michael Fuhr

pgsql-general by date:

Previous
From: John DeSoi
Date:
Subject: Re: storing PDFs
Next
From: Leonel Nunez
Date:
Subject: Re: storing PDFs