Обсуждение: psql tab completion for GRANT role
psql tab completion currently only supports the form GRANT privilege ON something TO someone (and the analogous REVOKE), but not the form GRANT role TO someone. Here is a patch that attempts to implement the latter.
Вложения
On Sun, Jan 8, 2012 at 3:48 PM, Peter Eisentraut <peter_e@gmx.net> wrote: > psql tab completion currently only supports the form GRANT privilege ON > something TO someone (and the analogous REVOKE), but not the form GRANT > role TO someone. Here is a patch that attempts to implement the latter. This seems to have fallen through the cracks. It doesn't apply any more, but one general comment is that it seems undesirable to repeatedly recapitulate the list of all privileges that exist in the system. That's a lot of places that someone will have to find and fix when new privileges are added. But +1 on the general idea. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On tor, 2012-06-14 at 13:38 -0400, Robert Haas wrote: > On Sun, Jan 8, 2012 at 3:48 PM, Peter Eisentraut <peter_e@gmx.net> wrote: > > psql tab completion currently only supports the form GRANT privilege ON > > something TO someone (and the analogous REVOKE), but not the form GRANT > > role TO someone. Here is a patch that attempts to implement the latter. > > This seems to have fallen through the cracks. No, it was committed in January.
On Tue, Jun 19, 2012 at 3:16 AM, Peter Eisentraut <peter_e@gmx.net> wrote: > On tor, 2012-06-14 at 13:38 -0400, Robert Haas wrote: >> On Sun, Jan 8, 2012 at 3:48 PM, Peter Eisentraut <peter_e@gmx.net> wrote: >> > psql tab completion currently only supports the form GRANT privilege ON >> > something TO someone (and the analogous REVOKE), but not the form GRANT >> > role TO someone. Here is a patch that attempts to implement the latter. >> >> This seems to have fallen through the cracks. > > No, it was committed in January. Oops, I missed that. Sorry for the noise. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company