Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

2017-08-10 Thread Colin 't Hart
Would this be a relatively easy patch for a beginning contributor? If so, I wouldn't mind having a go. /Colin On 9 August 2017 at 21:37, Melvin Davidson wrote: > > > On Wed, Aug 9, 2017 at 3:32 PM, David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Wed, Aug

Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

2017-08-09 Thread Melvin Davidson
On Wed, Aug 9, 2017 at 3:32 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Aug 9, 2017 at 12:26 PM, Melvin Davidson > wrote: > >> *>I'm am wondering whether "REASSIGNED OWNED" **needs fixing as well* >> >> *Possibly, but as the op is on 9.3, it is not

Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

2017-08-09 Thread David G. Johnston
On Wed, Aug 9, 2017 at 12:26 PM, Melvin Davidson wrote: > *>I'm am wondering whether "REASSIGNED OWNED" **needs fixing as well* > > *Possibly, but as the op is on 9.3, it is not available to him.* > ​You should check the docs again...​ > *I would also argue that since*

Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

2017-08-09 Thread Melvin Davidson
On Wed, Aug 9, 2017 at 3:00 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Aug 9, 2017 at 11:30 AM, Melvin Davidson > wrote: > >> >> >> On Wed, Aug 9, 2017 at 1:56 PM, David G. Johnston < >> david.g.johns...@gmail.com> wrote: >> >>> On Wed, Aug 9, 2017

Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

2017-08-09 Thread David G. Johnston
On Wed, Aug 9, 2017 at 11:30 AM, Melvin Davidson wrote: > > > On Wed, Aug 9, 2017 at 1:56 PM, David G. Johnston < > david.g.johns...@gmail.com> wrote: > >> On Wed, Aug 9, 2017 at 10:37 AM, Tom Lane wrote: >> >>> Scott Marlowe

Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

2017-08-09 Thread Melvin Davidson
On Wed, Aug 9, 2017 at 1:56 PM, David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Aug 9, 2017 at 10:37 AM, Tom Lane wrote: > >> Scott Marlowe writes: >> > Seems like something that should be handled by alter doesn't it? >> >> I have

Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

2017-08-09 Thread David G. Johnston
On Wed, Aug 9, 2017 at 10:37 AM, Tom Lane wrote: > Scott Marlowe writes: > > Seems like something that should be handled by alter doesn't it? > > I have some vague memory that we intentionally didn't implement > ALTER EXTENSION OWNER because we were

Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

2017-08-09 Thread Melvin Davidson
On Wed, Aug 9, 2017 at 12:19 PM, Scott Marlowe wrote: > On Wed, Aug 9, 2017 at 10:10 AM, Tom Lane wrote: > > Melvin Davidson writes: > >> *UPDATE pg_extensionSET extowner = {oid_of_new_owner} WHERE > extowner = > >>

Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

2017-08-09 Thread Tom Lane
Scott Marlowe writes: > Seems like something that should be handled by alter doesn't it? I have some vague memory that we intentionally didn't implement ALTER EXTENSION OWNER because we were unsure what it ought to do about ownership of objects belonging to the

Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

2017-08-09 Thread Scott Marlowe
On Wed, Aug 9, 2017 at 10:10 AM, Tom Lane wrote: > Melvin Davidson writes: >> *UPDATE pg_extensionSET extowner = {oid_of_new_owner} WHERE extowner = >> {oid_from_above_statement};* > > Note you'll also have to modify the rows in pg_shdepend that

Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

2017-08-09 Thread Tom Lane
Melvin Davidson writes: > *UPDATE pg_extensionSET extowner = {oid_of_new_owner} WHERE extowner = > {oid_from_above_statement};* Note you'll also have to modify the rows in pg_shdepend that reflect this ownership property. regards, tom lane --

Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

2017-08-09 Thread Melvin Davidson
On Wed, Aug 9, 2017 at 11:20 AM, Melvin Davidson wrote: > > On Wed, Aug 9, 2017 at 10:42 AM, Colin 't Hart > wrote: > >> Hi, >> >> Why does >> ALTER EXTENSION name OWNER TO new_owner; >> not exist? >> >> I have a bunch of extensions that were

Re: [GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

2017-08-09 Thread Melvin Davidson
On Wed, Aug 9, 2017 at 10:42 AM, Colin 't Hart wrote: > Hi, > > Why does > ALTER EXTENSION name OWNER TO new_owner; > not exist? > > I have a bunch of extensions that were installed by a role that I want > to drop. So I thought I would do like I do for other object types: >

[GENERAL] How to ALTER EXTENSION name OWNER TO new_owner ?

2017-08-09 Thread Colin 't Hart
Hi, Why does ALTER EXTENSION name OWNER TO new_owner; not exist? I have a bunch of extensions that were installed by a role that I want to drop. So I thought I would do like I do for other object types: ALTER name OWNER TO new_owner; But that doesn't exist for extensions. I also can't drop the