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
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
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*
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
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
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
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
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 =
> >>
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
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
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
--
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
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:
>
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
14 matches
Mail list logo