diff options
| author | Bruce Momjian | 2004-05-02 13:38:28 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2004-05-02 13:38:28 +0000 |
| commit | a9d3c2cb18ed4b0de982d649f6f8f9530a388d4a (patch) | |
| tree | 5f6689cf1db85709b1fdeb7b69a017cd4a401346 /src/test | |
| parent | 7ebd5dafd8d77555a1e3660d3936da05531a6d55 (diff) | |
Revert patch --- needs more generalized solution.
> Please find a attached a small patch that adds accessor functions
> for "aclitem" so that it is not an opaque datatype.
>
> I needed these functions to browse aclitems from user land. I can load
> them when necessary, but it seems to me that these accessors for a
> backend type belong to the backend, so I submit them.
>
> Fabien Coelho
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/privileges.out | 14 | ||||
| -rw-r--r-- | src/test/regress/sql/privileges.sql | 9 |
2 files changed, 0 insertions, 23 deletions
diff --git a/src/test/regress/expected/privileges.out b/src/test/regress/expected/privileges.out index fe1b8483a65..f5a6c039d54 100644 --- a/src/test/regress/expected/privileges.out +++ b/src/test/regress/expected/privileges.out @@ -581,20 +581,6 @@ SELECT has_table_privilege('regressuser1', 'atest4', 'SELECT WITH GRANT OPTION') t (1 row) --- aclitem utils small test -SELECT u1.usename AS u1, u2.usename AS u2, - aclitem_idtype(c.relacl[0]) AS idtype, - aclitem_privs(c.relacl[0]) AS privs, - aclitem_goptions(c.relacl[0]) AS goptions -FROM pg_class AS c, pg_user AS u1, pg_user AS u2 -WHERE u1.usesysid = aclitem_grantor(c.relacl[0]) - AND u2.usesysid = aclitem_grantee(c.relacl[0]) - AND c.relname LIKE 'atest4'; - u1 | u2 | idtype | privs | goptions ---------------+--------------+--------+-------+---------- - regressuser1 | regressuser1 | 1 | 127 | 127 -(1 row) - -- clean up \c regression DROP FUNCTION testfunc2(int); diff --git a/src/test/regress/sql/privileges.sql b/src/test/regress/sql/privileges.sql index dd33295277a..d3e9b543035 100644 --- a/src/test/regress/sql/privileges.sql +++ b/src/test/regress/sql/privileges.sql @@ -316,15 +316,6 @@ SELECT has_table_privilege('regressuser3', 'atest4', 'SELECT'); -- false SELECT has_table_privilege('regressuser1', 'atest4', 'SELECT WITH GRANT OPTION'); -- true --- aclitem utils small test -SELECT u1.usename AS u1, u2.usename AS u2, - aclitem_idtype(c.relacl[0]) AS idtype, - aclitem_privs(c.relacl[0]) AS privs, - aclitem_goptions(c.relacl[0]) AS goptions -FROM pg_class AS c, pg_user AS u1, pg_user AS u2 -WHERE u1.usesysid = aclitem_grantor(c.relacl[0]) - AND u2.usesysid = aclitem_grantee(c.relacl[0]) - AND c.relname LIKE 'atest4'; -- clean up |