public inbox for [email protected]  
help / color / mirror / Atom feed
Note addition to REASSIGN OWNED
4+ messages / 4 participants
[nested] [flat]

* Note addition to REASSIGN OWNED
@ 2010-05-06 03:24  Josh Berkus <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Josh Berkus @ 2010-05-06 03:24 UTC (permalink / raw)
  To: pgsql-docs

Need this sentence added in the Notes section of sql-reassign-owned:

REASSIGN OWNED will not reassign the ownership of any databases owned by 
the role.  These still need to be changed using ALTER DATABASE.

-- 
                                   -- Josh Berkus
                                      PostgreSQL Experts Inc.
                                      http://www.pgexperts.com



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Note addition to REASSIGN OWNED
@ 2010-05-06 16:10  Alvaro Herrera <[email protected]>
  parent: Josh Berkus <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Alvaro Herrera @ 2010-05-06 16:10 UTC (permalink / raw)
  To: Josh Berkus <[email protected]>; +Cc: pgsql-docs

Excerpts from Josh Berkus's message of mié may 05 23:24:44 -0400 2010:
> Need this sentence added in the Notes section of sql-reassign-owned:
> 
> REASSIGN OWNED will not reassign the ownership of any databases owned by 
> the role.  These still need to be changed using ALTER DATABASE.

I vaguely recall CONNECT privileges being similarly unhandled by REASSIGN
OWNED.  Do we really need to fix the docs, or should we fix the code?
-- 



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Note addition to REASSIGN OWNED
@ 2010-05-31 17:58  Bruce Momjian <[email protected]>
  parent: Alvaro Herrera <[email protected]>
  0 siblings, 1 reply; 4+ messages in thread

From: Bruce Momjian @ 2010-05-31 17:58 UTC (permalink / raw)
  To: Alvaro Herrera <[email protected]>; +Cc: Josh Berkus <[email protected]>; pgsql-docs

Alvaro Herrera wrote:
> Excerpts from Josh Berkus's message of mié may 05 23:24:44 -0400 2010:
> > Need this sentence added in the Notes section of sql-reassign-owned:
> > 
> > REASSIGN OWNED will not reassign the ownership of any databases owned by 
> > the role.  These still need to be changed using ALTER DATABASE.
> 
> I vaguely recall CONNECT privileges being similarly unhandled by REASSIGN
> OWNED.  Do we really need to fix the docs, or should we fix the code?

Where are we on this?

-- 
  Bruce Momjian  <[email protected]>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

  + None of us is going to be here forever. +




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: Note addition to REASSIGN OWNED
@ 2010-05-31 18:49  Alvaro Herrera <[email protected]>
  parent: Bruce Momjian <[email protected]>
  0 siblings, 0 replies; 4+ messages in thread

From: Alvaro Herrera @ 2010-05-31 18:49 UTC (permalink / raw)
  To: Bruce Momjian <[email protected]>; +Cc: Josh Berkus <[email protected]>; pgsql-docs

Excerpts from Bruce Momjian's message of lun may 31 13:58:36 -0400 2010:
> Alvaro Herrera wrote:
> > Excerpts from Josh Berkus's message of mi\xc3\xa9 may 05 23:24:44 -0400 2010:
> > > Need this sentence added in the Notes section of sql-reassign-owned:
> > > 
> > > REASSIGN OWNED will not reassign the ownership of any databases owned by 
> > > the role.  These still need to be changed using ALTER DATABASE.
> > 
> > I vaguely recall CONNECT privileges being similarly unhandled by REASSIGN
> > OWNED.  Do we really need to fix the docs, or should we fix the code?
> 
> Where are we on this?

I just patched the docs, slightly rewording Josh's suggestion.

-- 
Álvaro Herrera <[email protected]>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support




^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2010-05-31 18:49 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-05-06 03:24 Note addition to REASSIGN OWNED Josh Berkus <[email protected]>
2010-05-06 16:10 ` Alvaro Herrera <[email protected]>
2010-05-31 17:58   ` Bruce Momjian <[email protected]>
2010-05-31 18:49     ` Alvaro Herrera <[email protected]>

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox