Search Postgresql Archives

Re: How to ALTER EXTENSION name OWNER TO new_owner ?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: How to ALTER EXTENSION name OWNER TO new_owner ?
From: "David G. Johnston" <david.g.johnston@xxxxxxxxx>
Date: Wed, 9 Aug 2017 12:32:49 -0700
Cc: Tom Lane <tgl@xxxxxxxxxxxxx>, Scott Marlowe <scott.marlowe@xxxxxxxxx>, "Colin 't Hart" <colinthart@xxxxxxxxx>, "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
In-reply-to: <CANu8FixiTQOKQ6unEYC_ZVeW0LdVtaMKv-ALrZNDtYR0f-_M+w@mail.gmail.com>
References: <CAMon-aQ=4gtU29+YGWaRbrzKtjijVEYwUwvKfmCox0dtLArrwA@mail.gmail.com> <CANu8Fixm7w5RoCO95n_ETcR+mcVQd-FkBgAOic-9H+ZYrSeSwg@mail.gmail.com> <CANu8Fiw3tRsOOPmvOb-YUyOKCfmgTSSHmSU4xqAaPHrOeCN5mw@mail.gmail.com> <5665.1502295011@sss.pgh.pa.us> <CAOR=d=0FMYhc75yskUq11kG_P6NURKL7m45uNAgguKgwAPCT6Q@mail.gmail.com> <9769.1502300267@sss.pgh.pa.us> <CAKFQuwZF4md5pivbq67QLzY=_ftZ90kfckO93n-pYpwDv1UmhA@mail.gmail.com> <CANu8FizoFoWnBWUQpugSNMUsUQxjoX_3yjtpMmXSYQ0weo__cA@mail.gmail.com> <CAKFQuwatV-mGP--AEihQbNd6USKugORJgvvKfmaKGjUe=aK5LA@mail.gmail.com> <CANu8FixiTQOKQ6unEYC_ZVeW0LdVtaMKv-ALrZNDtYR0f-_M+w@mail.gmail.com>

On Wed, Aug 9, 2017 at 12:26 PM, Melvin Davidson <melvin6925@xxxxxxxxx> 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 "OWNER TO new_owner" is available in all other ALTER object statements, it is an omission and should be
included for extenstions as well..

As am I, but omission or not I don't recall that we've ever back-patched new SQL grammar.

David J.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Follow-Ups:
- Re: How to ALTER EXTENSION name OWNER TO new_owner ?
  - From: Melvin Davidson

References:
- How to ALTER EXTENSION name OWNER TO new_owner ?
  - From: Colin 't Hart
- Re: How to ALTER EXTENSION name OWNER TO new_owner ?
  - From: Melvin Davidson
- Re: How to ALTER EXTENSION name OWNER TO new_owner ?
  - From: Melvin Davidson
- Re: How to ALTER EXTENSION name OWNER TO new_owner ?
  - From: Tom Lane
- Re: How to ALTER EXTENSION name OWNER TO new_owner ?
  - From: Scott Marlowe
- Re: How to ALTER EXTENSION name OWNER TO new_owner ?
  - From: Tom Lane
- Re: How to ALTER EXTENSION name OWNER TO new_owner ?
  - From: David G. Johnston
- Re: How to ALTER EXTENSION name OWNER TO new_owner ?
  - From: Melvin Davidson
- Re: How to ALTER EXTENSION name OWNER TO new_owner ?
  - From: David G. Johnston
- Re: How to ALTER EXTENSION name OWNER TO new_owner ?
  - From: Melvin Davidson

Prev by Date: Re: Multixact members limit exceeded
Next by Date: Re: How to ALTER EXTENSION name OWNER TO new_owner ?
Previous by thread: Re: How to ALTER EXTENSION name OWNER TO new_owner ?
Next by thread: Re: How to ALTER EXTENSION name OWNER TO new_owner ?
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]