diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/expected/privileges_1.out | 165 |
1 files changed, 68 insertions, 97 deletions
diff --git a/src/test/regress/expected/privileges_1.out b/src/test/regress/expected/privileges_1.out index cd1babb918..b623962be7 100644 --- a/src/test/regress/expected/privileges_1.out +++ b/src/test/regress/expected/privileges_1.out @@ -851,35 +851,20 @@ SELECT has_sequence_privilege('x_seq', 'USAGE'); \c - SET SESSION AUTHORIZATION regressuser1; SELECT lo_create(1001); - lo_create ------------ - 1001 -(1 row) - +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lo_create(1002); - lo_create ------------ - 1002 -(1 row) - +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lo_create(1003); - lo_create ------------ - 1003 -(1 row) - +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lo_create(1004); - lo_create ------------ - 1004 -(1 row) - +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lo_create(1005); - lo_create ------------ - 1005 -(1 row) - +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported GRANT ALL ON LARGE OBJECT 1001 TO PUBLIC; ERROR: large object 1001 does not exist GRANT SELECT ON LARGE OBJECT 1003 TO regressuser2; @@ -899,33 +884,35 @@ ERROR: large object 999 does not exist \c - SET SESSION AUTHORIZATION regressuser2; SELECT lo_create(2001); - lo_create ------------ - 2001 -(1 row) - +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lo_create(2002); - lo_create ------------ - 2002 -(1 row) - +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT loread(lo_open(1001, x'40000'::int), 32); -ERROR: permission denied for large object 1001 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT loread(lo_open(1002, x'40000'::int), 32); -- to be denied -ERROR: permission denied for large object 1002 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT loread(lo_open(1003, x'40000'::int), 32); -ERROR: permission denied for large object 1003 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT loread(lo_open(1004, x'40000'::int), 32); -ERROR: permission denied for large object 1004 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lowrite(lo_open(1001, x'20000'::int), 'abcd'); -ERROR: permission denied for large object 1001 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lowrite(lo_open(1002, x'20000'::int), 'abcd'); -- to be denied -ERROR: permission denied for large object 1002 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lowrite(lo_open(1003, x'20000'::int), 'abcd'); -- to be denied -ERROR: permission denied for large object 1003 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lowrite(lo_open(1004, x'20000'::int), 'abcd'); -ERROR: permission denied for large object 1004 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported GRANT SELECT ON LARGE OBJECT 1005 TO regressuser3; ERROR: large object 1005 does not exist GRANT UPDATE ON LARGE OBJECT 1006 TO regressuser3; -- to be denied @@ -935,82 +922,71 @@ ERROR: large object 2001 does not exist GRANT ALL ON LARGE OBJECT 2001 TO regressuser3; ERROR: large object 2001 does not exist SELECT lo_unlink(1001); -- to be denied -ERROR: must be owner of large object 1001 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lo_unlink(2002); - lo_unlink ------------ - 1 -(1 row) - +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported \c - -- confirm ACL setting SELECT oid, pg_get_userbyid(lomowner) ownername, lomacl FROM pg_largeobject_metadata; - oid | ownername | lomacl -------+--------------+-------- - 1001 | regressuser1 | - 1002 | regressuser1 | - 1003 | regressuser1 | - 1004 | regressuser1 | - 1005 | regressuser1 | - 2001 | regressuser2 | -(6 rows) + oid | ownername | lomacl +-----+-----------+-------- +(0 rows) SET SESSION AUTHORIZATION regressuser3; SELECT loread(lo_open(1001, x'40000'::int), 32); -ERROR: permission denied for large object 1001 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT loread(lo_open(1003, x'40000'::int), 32); -- to be denied -ERROR: permission denied for large object 1003 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT loread(lo_open(1005, x'40000'::int), 32); -ERROR: permission denied for large object 1005 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lo_truncate(lo_open(1005, x'20000'::int), 10); -- to be denied -ERROR: permission denied for large object 1005 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lo_truncate(lo_open(2001, x'20000'::int), 10); -ERROR: permission denied for large object 2001 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported -- compatibility mode in largeobject permission \c - SET lo_compat_privileges = false; -- default setting SET SESSION AUTHORIZATION regressuser4; SELECT loread(lo_open(1002, x'40000'::int), 32); -- to be denied -ERROR: permission denied for large object 1002 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lowrite(lo_open(1002, x'20000'::int), 'abcd'); -- to be denied -ERROR: permission denied for large object 1002 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lo_truncate(lo_open(1002, x'20000'::int), 10); -- to be denied -ERROR: permission denied for large object 1002 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lo_unlink(1002); -- to be denied -ERROR: must be owner of large object 1002 +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lo_export(1001, '/dev/null'); -- to be denied -ERROR: must be superuser to use server-side lo_export() -HINT: Anyone can use the client-side lo_export() provided by libpq. +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported \c - SET lo_compat_privileges = true; -- compatibility mode SET SESSION AUTHORIZATION regressuser4; SELECT loread(lo_open(1002, x'40000'::int), 32); - loread --------- - \x -(1 row) - +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lowrite(lo_open(1002, x'20000'::int), 'abcd'); - lowrite ---------- - 4 -(1 row) - +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lo_truncate(lo_open(1002, x'20000'::int), 10); - lo_truncate -------------- - 0 -(1 row) - +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lo_unlink(1002); - lo_unlink ------------ - 1 -(1 row) - +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported SELECT lo_export(1001, '/dev/null'); -- to be denied -ERROR: must be superuser to use server-side lo_export() -HINT: Anyone can use the client-side lo_export() provided by libpq. +ERROR: Postgres-XC does not support large object yet +DETAIL: The feature is not currently supported -- don't allow unpriv users to access pg_largeobject contents \c - SELECT * FROM pg_largeobject LIMIT 0; @@ -1210,12 +1186,7 @@ DROP TABLE atestp2; SELECT lo_unlink(oid) FROM pg_largeobject_metadata; lo_unlink ----------- - 1 - 1 - 1 - 1 - 1 -(5 rows) +(0 rows) DROP GROUP regressgroup1; DROP GROUP regressgroup2; |