Re: wrong message on REASSIGN OWNED

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(at)2ndquadrant(dot)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(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support