Commitb9eb0ff

committed

Rename pg_checkpointer predefined role to pg_checkpoint.

This is more consistent with how other predefined roles that conferspecific privileges are named.Nathan BosartDiscussion:http://postgr.es/m/CA+TgmoatH7+yYe+A8uJFNogg3VUDtFE6c-77yHAY8TRWR7oqyw@mail.gmail.com

1 parent09878cd commitb9eb0ffCopy full SHA for b9eb0ff

File tree

-7

lines changed

-7

lines changed

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -53,7 +53,7 @@ CHECKPOINT`
`53`	`53`
`54`	`54`	`<para>`
`55`	`55`	`Only superusers or users with the privileges of`
`56`		`- the <link linkend="predefined-roles-table"><literal>pg_checkpointer</literal></link>`
	`56`	`+ the <link linkend="predefined-roles-table"><literal>pg_checkpoint</literal></link>`
`57`	`57`	`role can call <command>CHECKPOINT</command>.`
`58`	`58`	`</para>`
`59`	`59`	`</refsect1>`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -583,7 +583,7 @@ DROP ROLE doomed_role;`
`583`	`583`	`COPY and other functions which allow executing a server-side program.</entry>`
`584`	`584`	`</row>`
`585`	`585`	`<row>`
`586`		`- <entry>pg_checkpointer</entry>`
	`586`	`+ <entry>pg_checkpoint</entry>`
`587`	`587`	`<entry>Allow executing`
`588`	`588`	`the <link linkend="sql-checkpoint"><command>CHECKPOINT</command></link>`
`589`	`589`	`command.</entry>`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -947,10 +947,10 @@ standard_ProcessUtility(PlannedStmt *pstmt,`
`947`	`947`	`break;`
`948`	`948`
`949`	`949`	`caseT_CheckPointStmt:`
`950`		`-if (!has_privs_of_role(GetUserId(),ROLE_PG_CHECKPOINTER))`
	`950`	`+if (!has_privs_of_role(GetUserId(),ROLE_PG_CHECKPOINT))`
`951`	`951`	`ereport(ERROR,`
`952`	`952`	`(errcode(ERRCODE_INSUFFICIENT_PRIVILEGE),`
`953`		`-errmsg("must be superuser or have privileges ofpg_checkpointer to do CHECKPOINT")));`
	`953`	`+errmsg("must be superuser or have privileges ofpg_checkpoint to do CHECKPOINT")));`
`954`	`954`
`955`	`955`	`RequestCheckpoint(CHECKPOINT_IMMEDIATE \|CHECKPOINT_WAIT \|`
`956`	`956`	`(RecoveryInProgress() ?0 :CHECKPOINT_FORCE));`

Lines changed: 1 addition & 1 deletion

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -79,8 +79,8 @@`
`79`	`79`	`rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',`
`80`	`80`	`rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',`
`81`	`81`	`rolpassword => '_null_', rolvaliduntil => '_null_' },`
`82`		`-{ oid => '4544', oid_symbol => 'ROLE_PG_CHECKPOINTER',`
`83`		`- rolname => 'pg_checkpointer', rolsuper => 'f', rolinherit => 't',`
	`82`	`+{ oid => '4544', oid_symbol => 'ROLE_PG_CHECKPOINT',`
	`83`	`+ rolname => 'pg_checkpoint', rolsuper => 'f', rolinherit => 't',`
`84`	`84`	`rolcreaterole => 'f', rolcreatedb => 'f', rolcanlogin => 'f',`
`85`	`85`	`rolreplication => 'f', rolbypassrls => 'f', rolconnlimit => '-1',`
`86`	`86`	`rolpassword => '_null_', rolvaliduntil => '_null_' },`

Comments

(0)