Re: refactoring a database owner without "reassign owned"

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
Cc: Vincent Veyron <vv(dot)lists(at)wanadoo(dot)fr>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: refactoring a database owner without "reassign owned"
Date: 2013-05-13 21:00:20
Message-ID: 20130513210020.GC3521@eldon.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jeff Janes 2013-05-13 22:12:04 Re: refactoring a database owner without "reassign owned"
Previous Message Vincent Veyron 2013-05-13 20:51:22 Re: Update from select