| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | antonov(at)stdpr(dot)ru |
| Cc: | pgsql-docs(at)postgresql(dot)org |
| Subject: | Re: "$user" and SESSION_USER and CURRENT_USER |
| Date: | 2018-12-20 18:42:32 |
| Message-ID: | 9732.1545331352@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
antonov(at)stdpr(dot)ru writes:
> here -- https://www.postgresql.org/docs/11/runtime-config-client.html
> there is the text """If one of the list items is the special name $user,
> then the schema having the name returned by SESSION_USER is substituted,
> if there is such a schema and the user has USAGE permission for it. (If
> not, $user is ignored.)""".
> but actualy "$user" substitutes CURRENT_USER-value (not
> SESSION_USER-value).
Huh. Digging in the commit history, SESSION_USER was the original
implementation (commit 838fe25a9 of 2002-04-01) but it was changed later
that month (ccfaf9067 of 2002-04-29) when we added schema permissions
checks. Evidently I forgot to update the docs to match :-(
Will fix, thanks for noticing!
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | PG Doc comments form | 2018-12-21 07:10:02 | The documentation on Partitions does not document the DEFAULT partition |
| Previous Message | antonov | 2018-12-20 15:38:26 | "$user" and SESSION_USER and CURRENT_USER |