diff options
| author | Michael Paquier <michael@paquier.xyz> | 2024-07-10 10:14:37 +0900 |
|---|---|---|
| committer | Michael Paquier <michael@paquier.xyz> | 2024-07-10 10:14:37 +0900 |
| commit | d898665bf7591514158954038ac43cea3240beaa (patch) | |
| tree | fbb770968dcb96bfcccc6efc43a9fc30750fdea1 /doc/src | |
| parent | f7bd0a381de12a5c309f3c19d8c966b77e87cff3 (diff) | |
| download | postgresql-d898665bf7591514158954038ac43cea3240beaa.tar.gz postgresql-d898665bf7591514158954038ac43cea3240beaa.zip | |
Extend pg_get_acl() to handle sub-object IDs
This patch modifies the pg_get_acl() function to accept a third argument
called "objsubid", bringing it on par with similar functions in this
area like pg_describe_object(). This enables the retrieval of ACLs for
relation attributes when scanning dependencies.
Bump catalog version.
Author: Joel Jacobson
Discussion: https://postgr.es/m/f2539bff-64be-47f0-9f0b-df85d3cc0432@app.fastmail.com
Diffstat (limited to 'doc/src')
| -rw-r--r-- | doc/src/sgml/func.sgml | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/doc/src/sgml/func.sgml b/doc/src/sgml/func.sgml index f1ce1db6bcd..135590ba574 100644 --- a/doc/src/sgml/func.sgml +++ b/doc/src/sgml/func.sgml @@ -26661,12 +26661,12 @@ SELECT currval(pg_get_serial_sequence('sometable', 'id')); <indexterm> <primary>pg_get_acl</primary> </indexterm> - <function>pg_get_acl</function> ( <parameter>classid</parameter> <type>oid</type>, <parameter>objid</parameter> <type>oid</type> ) + <function>pg_get_acl</function> ( <parameter>classid</parameter> <type>oid</type>, <parameter>objid</parameter> <type>oid</type>, <parameter>objsubid</parameter> <type>integer</type> ) <returnvalue>aclitem[]</returnvalue> </para> <para> Returns the <acronym>ACL</acronym> for a database object, specified - by catalog OID and object OID. This function returns + by catalog OID, object OID and sub-object ID. This function returns <literal>NULL</literal> values for undefined objects. </para></entry> </row> @@ -26792,7 +26792,7 @@ SELECT currval(pg_get_serial_sequence('sometable', 'id')); <programlisting> postgres=# SELECT (pg_identify_object(s.classid,s.objid,s.objsubid)).*, - pg_catalog.pg_get_acl(s.classid,s.objid) AS acl + pg_catalog.pg_get_acl(s.classid,s.objid,s.objsubid) AS acl FROM pg_catalog.pg_shdepend AS s JOIN pg_catalog.pg_database AS d ON d.datname = current_database() AND |