diff options
| author | Stephen Frost <sfrost@snowman.net> | 2015-01-28 21:47:15 -0500 |
|---|---|---|
| committer | Stephen Frost <sfrost@snowman.net> | 2015-01-28 21:47:15 -0500 |
| commit | c7cf9a243336d5f48bb4a4297c9fba4210f3e981 (patch) | |
| tree | b0667d17afb41b769ae7f61ddc9ac1c5c032b4a0 /src | |
| parent | f8519a6a464c92730dfa21298022f74d105f54d4 (diff) | |
| download | postgresql-c7cf9a243336d5f48bb4a4297c9fba4210f3e981.tar.gz postgresql-c7cf9a243336d5f48bb4a4297c9fba4210f3e981.zip | |
Add usebypassrls to pg_user and pg_shadow
The row level security patches didn't add the 'usebypassrls' columns to
the pg_user and pg_shadow views on the belief that they were deprecated,
but we havn't actually said they are and therefore we should include it.
This patch corrects that, adds missing documentation for rolbypassrls
into the system catalog page for pg_authid, along with the entries for
pg_user and pg_shadow, and cleans up a few other uses of 'row-level'
cases to be 'row level' in the docs.
Pointed out by Amit Kapila.
Catalog version bump due to system view changes.
Diffstat (limited to 'src')
| -rw-r--r-- | src/backend/catalog/system_views.sql | 2 | ||||
| -rw-r--r-- | src/include/catalog/catversion.h | 2 | ||||
| -rw-r--r-- | src/test/regress/expected/rules.out | 2 |
3 files changed, 5 insertions, 1 deletions
diff --git a/src/backend/catalog/system_views.sql b/src/backend/catalog/system_views.sql index 6df6bf27d19..5e69e2b2add 100644 --- a/src/backend/catalog/system_views.sql +++ b/src/backend/catalog/system_views.sql @@ -33,6 +33,7 @@ CREATE VIEW pg_shadow AS rolsuper AS usesuper, rolcatupdate AS usecatupd, rolreplication AS userepl, + rolbypassrls AS usebypassrls, rolpassword AS passwd, rolvaliduntil::abstime AS valuntil, setconfig AS useconfig @@ -58,6 +59,7 @@ CREATE VIEW pg_user AS usesuper, usecatupd, userepl, + usebypassrls, '********'::text as passwd, valuntil, useconfig diff --git a/src/include/catalog/catversion.h b/src/include/catalog/catversion.h index 13c4376b8cc..2b7a0bb93bc 100644 --- a/src/include/catalog/catversion.h +++ b/src/include/catalog/catversion.h @@ -53,6 +53,6 @@ */ /* yyyymmddN */ -#define CATALOG_VERSION_NO 201501241 +#define CATALOG_VERSION_NO 201501281 #endif diff --git a/src/test/regress/expected/rules.out b/src/test/regress/expected/rules.out index 7df5d2dce9a..d50b103f159 100644 --- a/src/test/regress/expected/rules.out +++ b/src/test/regress/expected/rules.out @@ -1609,6 +1609,7 @@ pg_shadow| SELECT pg_authid.rolname AS usename, pg_authid.rolsuper AS usesuper, pg_authid.rolcatupdate AS usecatupd, pg_authid.rolreplication AS userepl, + pg_authid.rolbypassrls AS usebypassrls, pg_authid.rolpassword AS passwd, (pg_authid.rolvaliduntil)::abstime AS valuntil, s.setconfig AS useconfig @@ -2063,6 +2064,7 @@ pg_user| SELECT pg_shadow.usename, pg_shadow.usesuper, pg_shadow.usecatupd, pg_shadow.userepl, + pg_shadow.usebypassrls, '********'::text AS passwd, pg_shadow.valuntil, pg_shadow.useconfig |