Re: refactoring a database owner without "reassign owned" - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: refactoring a database owner without "reassign owned"
Date
Msg-id 20130513210020.GC3521@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: refactoring a database owner without "reassign owned"  (Jeff Janes <jeff.janes@gmail.com>)
Responses Re: refactoring a database owner without "reassign owned"  (Jeff Janes <jeff.janes@gmail.com>)
List pgsql-general
Jeff Janes escribió:

> I think "reassign owned" should detect that it is being invoked on the
> internal user (as it does now) but then instead of refusing to run, it
> should DWIM.  I suppose that was not implemented because it is difficult to
> do so (but of course that is all the more reason not to leave it to the dba
> to figure out how to do it themselves).  Perhaps this is a todo item?

Hm, so what would you have it do, precisely?

--
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


pgsql-general by date:

Previous
From: Vincent Veyron
Date:
Subject: Re: Update from select
Next
From: Jeff Janes
Date:
Subject: Re: refactoring a database owner without "reassign owned"