Re: [HACKERS] wrong message on REASSIGN OWNED

2011-06-13 Thread Alvaro Herrera
Excerpts from Tom Lane's message of lun jun 13 09:57:50 -0400 2011: > Jaime Casanova writes: > > On Sat, Jun 11, 2011 at 8:01 PM, Robert Haas wrote: > >> "can't reassign objects owned by %s because this user is internal to > >> the database system" ? > > > that message is not that clear... it se

Re: [HACKERS] wrong message on REASSIGN OWNED

2011-06-13 Thread Jaime Casanova
On Mon, Jun 13, 2011 at 10:37 AM, Alvaro Herrera wrote: > 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 wrote: >> > on shdepReassignOwned() we have this message, which is obviously wrong >> > we are not dropping objects ju

Re: [HACKERS] wrong message on REASSIGN OWNED

2011-06-13 Thread Alvaro Herrera
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 wrote: > > on shdepReassignOwned() we have this message, which is obviously wrong > > we are not dropping objects just reassigning them... > > """ > >                       erepo

Re: [HACKERS] wrong message on REASSIGN OWNED

2011-06-13 Thread Jaime Casanova
On Mon, Jun 13, 2011 at 8:55 AM, Tom Lane wrote: > Robert Haas writes: >> On Mon, Jun 13, 2011 at 2:41 AM, Jaime Casanova >> 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 tha

Re: [HACKERS] wrong message on REASSIGN OWNED

2011-06-13 Thread Andrew Dunstan
On 06/13/2011 09:55 AM, Tom Lane wrote: Robert Haas writes: On Mon, Jun 13, 2011 at 2:41 AM, Jaime Casanova 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.

Re: [HACKERS] wrong message on REASSIGN OWNED

2011-06-13 Thread Robert Haas
On Mon, Jun 13, 2011 at 9:55 AM, Tom Lane wrote: > Robert Haas writes: >> On Mon, Jun 13, 2011 at 2:41 AM, Jaime Casanova >> 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 tha

Re: [HACKERS] wrong message on REASSIGN OWNED

2011-06-13 Thread Tom Lane
Jaime Casanova writes: > On Sat, Jun 11, 2011 at 8:01 PM, Robert Haas wrote: >> "can't reassign objects owned by %s because this user is internal to >> the database system" ? > that message is not that clear... it seems to imply i can't reassign > any object from that user... I think s/drop/rea

Re: [HACKERS] wrong message on REASSIGN OWNED

2011-06-13 Thread Tom Lane
Robert Haas writes: > On Mon, Jun 13, 2011 at 2:41 AM, Jaime Casanova 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 "DELET

Re: [HACKERS] wrong message on REASSIGN OWNED

2011-06-13 Thread Robert Haas
On Mon, Jun 13, 2011 at 2:41 AM, Jaime Casanova wrote: > On Sat, Jun 11, 2011 at 8:01 PM, Robert Haas wrote: >> >> "can't reassign objects owned by %s because this user is internal to >> the database system" ? >> > > that message is not that clear... it seems to imply i can't reassign > any objec

Re: [HACKERS] wrong message on REASSIGN OWNED

2011-06-12 Thread Jaime Casanova
On Sat, Jun 11, 2011 at 8:01 PM, Robert Haas wrote: > > "can't reassign objects owned by %s because this user is internal to > the database system" ? > that message is not that clear... it seems to imply i can't reassign any object from that user... btw, i'm allowed to use ALTER TABLE to assign

Re: [HACKERS] wrong message on REASSIGN OWNED

2011-06-11 Thread Robert Haas
On Thu, Jun 9, 2011 at 1:26 PM, Jaime Casanova 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), >                

[HACKERS] wrong message on REASSIGN OWNED

2011-06-09 Thread Jaime Casanova
Hi, 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 bec