diff options
| author | Bruce Momjian <bruce@momjian.us> | 1999-02-22 02:08:32 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 1999-02-22 02:08:32 +0000 |
| commit | 47dd11bdd034a8afeab5e9a3ed12ddbebb475d25 (patch) | |
| tree | b54dfc9e852c819cc1fc6857619ffe4f31eba49e /src | |
| parent | e23623584f5cec1ca8344c2b07ac2f1da2099471 (diff) | |
| download | postgresql-47dd11bdd034a8afeab5e9a3ed12ddbebb475d25.tar.gz postgresql-47dd11bdd034a8afeab5e9a3ed12ddbebb475d25.zip | |
rename pgsql to postgres in regression.
Diffstat (limited to 'src')
| -rw-r--r-- | src/test/regress/sql/view_perms.sql | 18 |
1 files changed, 9 insertions, 9 deletions
diff --git a/src/test/regress/sql/view_perms.sql b/src/test/regress/sql/view_perms.sql index 5a72e88a3a1..aed0ac7ce5c 100644 --- a/src/test/regress/sql/view_perms.sql +++ b/src/test/regress/sql/view_perms.sql @@ -54,8 +54,8 @@ CREATE VIEW viewperms_v7 AS SELECT * FROM viewperms_v2; -- v2 pgslq -- v3 tuser -- v4 tuser --- v5 pgsql --- v6 pgsql +-- v5 postgres +-- v6 postgres -- v7 tuser -- UPDATE pg_class SET relowner = viewperms_testid() @@ -71,31 +71,31 @@ UPDATE pg_class SET relowner = viewperms_testid() -- Now for the tests. -- --- View v1 owner pgsql has access to t1 owned by tuser +-- View v1 owner postgres has access to t1 owned by tuser SELECT * FROM viewperms_v1; --- View v2 owner pgsql has access to t2 owned by pgsql (of cause) +-- View v2 owner postgres has access to t2 owned by postgres (of cause) SELECT * FROM viewperms_v2; -- View v3 owner tuser has access to t1 owned by tuser SELECT * FROM viewperms_v3; --- View v4 owner tuser has NO access to t2 owned by pgsql +-- View v4 owner tuser has NO access to t2 owned by postgres -- MUST fail with permission denied SELECT * FROM viewperms_v4; --- v5 (pgsql) can access v2 (pgsql) can access t1 (tuser) +-- v5 (postgres) can access v2 (postgres) can access t1 (tuser) SELECT * FROM viewperms_v5; --- v6 (pgsql) can access v4 (tuser) CANNOT access t2 (pgsql) +-- v6 (postgres) can access v4 (tuser) CANNOT access t2 (postgres) SELECT * FROM viewperms_v6; --- v7 (tuser) CANNOT access v2 (pgsql) wanna access t2 (pgslq) +-- v7 (tuser) CANNOT access v2 (postgres) wanna access t2 (pgslq) SELECT * FROM viewperms_v7; GRANT SELECT ON viewperms_v2 TO PUBLIC; -- but now --- v7 (tuser) can access v2 (pgsql via grant) can access t2 (pgsql) +-- v7 (tuser) can access v2 (postgres via grant) can access t2 (postgres) SELECT * FROM viewperms_v7; -- |