Re: wrong message on REASSIGN OWNED - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: wrong message on REASSIGN OWNED
Date
Msg-id 4DF61B31.5020404@dunslane.net
Whole thread Raw
In response to Re: wrong message on REASSIGN OWNED  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers

On 06/13/2011 09:55 AM, Tom Lane wrote:
> Robert Haas<robertmhaas@gmail.com>  writes:
>> On Mon, Jun 13, 2011 at 2:41 AM, Jaime Casanova<jaime@2ndquadrant.com>  wrote:
>>> btw, i'm allowed to use ALTER TABLE to assign a new owner (even an
>>> unprivileged one) to a system catalog, probably that's a bug.
>> +1 for tightening that up in 9.2.
> Nonsense.  You won't like the results of "DELETE FROM pg_proc;" either,
> but we don't try to put training wheels on superusers.


Yeah. Amusing anecdote along these lines: I had fun recently recovering 
the situation for someone who had for reasons I can't even imagine done 
"delete from pg_database;" on their production system.

cheers

andrew




pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Boolean operators without commutators vs. ALL/ANY
Next
From: Andrew Dunstan
Date:
Subject: Re: Boolean operators without commutators vs. ALL/ANY