From: Stephen Frost <sfrost@snowman.net>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Adam Brightwell <adam.brightwell@crunchydatasolutions.com>
Cc: Peter Eisentraut <peter_e@gmx.net>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Noah Misch <noah@leadboat.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: CATUPDATE confusion?
Date: Mon, 16 Mar 2015 11:56:50 -0400
Message-ID: <20150316155650.GP29780@tamriel.snowman.net> (raw)
In-Reply-To: <CA+TgmoanWZqp0gNhZTmPRT5ceJdscG+-0a7nRZLjiCookJGjwQ@mail.gmail.com>
References: <4593.1425706263@sss.pgh.pa.us>
<54FB0708.7070200@gmx.net>
<20150307142441.GD29780@tamriel.snowman.net>
<CAKRt6CRJVrSixLPfQQDh5k9rkviCxCv8CvFhr_wuB8HMwX-BDA@mail.gmail.com>
<CA+TgmoaCea0wKzT0W4z7onHTVzogemP5Za+6wwWKsC4WJoin5A@mail.gmail.com>
<20150313023617.GX29780@tamriel.snowman.net>
<CA+TgmoZshwViqpXO7G_qmoALyi1v3FGAn3aBJwwRTzGw=0ZBgw@mail.gmail.com>
<20150313134742.GZ29780@tamriel.snowman.net>
<20150313135221.GB29780@tamriel.snowman.net>
<CA+TgmoanWZqp0gNhZTmPRT5ceJdscG+-0a7nRZLjiCookJGjwQ@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>
* Robert Haas (robertmhaas@gmail.com) wrote:
> On Fri, Mar 13, 2015 at 9:52 AM, Stephen Frost <sfrost@snowman.net> wrote:
> > * Stephen Frost (sfrost@snowman.net) wrote:
> >> I should have been more specific. I don't believe they've moved to
> >> using pg_roles completely (which was created specifically to address the
> >> issue that regular users can't select from pg_authid).
> >
> > Err, forgot to finish that thought, sorry. Let's try again:
> >
> > I should have been more specific. I don't believe they've moved to
> > using pg_roles completely (which was created specifically to address the
> > issue that regular users can't select from pg_authid) simply because
> > they haven't had reason to.
>
> That's another way of saying "removing pg_user would be creating extra
> work for tool authors that otherwise wouldn't need to be done".
Sure, if we never deprecate anything then tool authors would never need
to change their existing code. I don't think that's actually a viable
solution though; the reason we're discussing the removal of these
particular views is that they aren't really being maintained and, when
they are, they're making work for us. That's certainly a trade-off to
consider, of course, but in this case I'm coming down on the side of
dropping support and our own maintenance costs associated with these
views in favor of asking the tooling community to complete the migration
to the new views which have been around for the past 10 years.
Thanks!
Stephen
Attachments:
signature.asc (application/pgp-signature, 818B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-hackers@postgresql.org
Cc: sfrost@snowman.net, robertmhaas@gmail.com, adam.brightwell@crunchydatasolutions.com, peter_e@gmx.net, tgl@sss.pgh.pa.us, noah@leadboat.com
Subject: Re: CATUPDATE confusion?
In-Reply-To: <20150316155650.GP29780@tamriel.snowman.net>
References: <4593.1425706263@sss.pgh.pa.us> <54FB0708.7070200@gmx.net> <20150307142441.GD29780@tamriel.snowman.net> <CAKRt6CRJVrSixLPfQQDh5k9rkviCxCv8CvFhr_wuB8HMwX-BDA@mail.gmail.com> <CA+TgmoaCea0wKzT0W4z7onHTVzogemP5Za+6wwWKsC4WJoin5A@mail.gmail.com> <20150313023617.GX29780@tamriel.snowman.net> <CA+TgmoZshwViqpXO7G_qmoALyi1v3FGAn3aBJwwRTzGw=0ZBgw@mail.gmail.com> <20150313134742.GZ29780@tamriel.snowman.net> <20150313135221.GB29780@tamriel.snowman.net> <CA+TgmoanWZqp0gNhZTmPRT5ceJdscG+-0a7nRZLjiCookJGjwQ@mail.gmail.com> <20150316155650.GP29780@tamriel.snowman.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox