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

From Alvaro Herrera
Subject Re: wrong message on REASSIGN OWNED
Date
Msg-id 1307979413-sup-7534@alvh.no-ip.org
Whole thread Raw
In response to Re: wrong message on REASSIGN OWNED  (Robert Haas <robertmhaas@gmail.com>)
Responses Re: wrong message on REASSIGN OWNED
List pgsql-hackers
Excerpts from Robert Haas's message of sáb jun 11 21:01:55 -0400 2011:
> On Thu, Jun 9, 2011 at 1:26 PM, Jaime Casanova <jaime@2ndquadrant.com> wrote:
> > on shdepReassignOwned() we have this message, which is obviously wrong
> > we are not dropping objects just reassigning them...
> > """
> >                       ereport(ERROR,
> >
> > (errcode(ERRCODE_DEPENDENT_OBJECTS_STILL_EXIST),
> >                                   errmsg("cannot drop objects owned
> > by %s because they are "
> >                                                  "required by the
> > database system",
> >                                                  getObjectDescription(&obj))));
> > """

Oh my.  I introduced this mistake 6 years ago and nobody noticed in all
this time.  I guess this is not a very frequently used feature.

> > but haven't thought of a good way of rephrase it
> 
> "can't reassign objects owned by %s because this user is internal to
> the database system" ?

Thanks, I'll use that.

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: DOMAINs and CASTs
Next
From: Andrew Dunstan
Date:
Subject: Re: FOREIGN TABLE doc fix