Date: Mon, 16 Mar 2015 11:56:50 -0400
From: Stephen Frost <sfrost@snowman.net>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Adam Brightwell <adam.brightwell@crunchydatasolutions.com>,
 Peter Eisentraut <peter_e@gmx.net>, Tom Lane <tgl@sss.pgh.pa.us>,
 Noah Misch <noah@leadboat.com>,
 PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Subject: Re: CATUPDATE confusion?
Message-ID: <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>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
 protocol="application/pgp-signature"; boundary="17ExsrJJVvsc15xs"
Content-Disposition: inline
In-Reply-To: 
 <CA+TgmoanWZqp0gNhZTmPRT5ceJdscG+-0a7nRZLjiCookJGjwQ@mail.gmail.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org


--17ExsrJJVvsc15xs
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

* 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 t=
he
> >> 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.
>=20
> 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

--17ExsrJJVvsc15xs
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1

iQIcBAEBCgAGBQJVBv1CAAoJEO1sijiDR2RVt5wP/ArisqFZRo+jOOTk31BjjMuO
58j4lTuKpoHPmQuzqg8Sz8i56CZmNZfAYfOKquABu1T8BXlPcI4pH8JaJ5eJYFAH
MFExFsZQhHxhlPmMFtDn7mZLOVG45xPqADBjh7+O8Ytr67jd0xJWbQ5DnuvZhbOK
kx4e7E4Cs2rwNg7aIRCErZl+BPejBjj/8R0wycNkFBJ8cUu0UvJ683z8KATlu/Jo
Mz/AEpgT9Lg5IJ9TfjsYclG2w0faBAyLZ1yzRHUjkXNTYZ1/dAVMnVeS0Y7zxw64
Jf3XKuubboPR6AZyzT5I4MiSKMKYPYweyVTX1UavMWPGBFvoC4usowtGXLI8kjHM
kK4T86Z45PbPSneYl8pMPOozl5wJKio8nWpiKio5gppYGawcA+F7QRryLeaanppz
Lh7RmSUe9Ne6E6X5EL1Ge4X8+MDIxD38uqURpXPCifwEfmgBBNpQRwMJEXv5g+YI
TZo55FgjB0UIt/dQj/aSF9YCim7pAI36eM0/Q12cpJ/5hsrkpsqRr0XBwuooLn7T
vSrJiDrlfVIsL3xf6+345y6Zh2qxTVHfSVEAzu16vT8D3GUXavRY+fzG9pO2qdXa
d05sPLUFY+qKrnJGeCQgy2r5VChXBMYbDZ6cPNMIMlbF01l3s0hyq8I8X+CmrxfQ
uGI+a1OG0A0g/8bV461Y
=V1CH
-----END PGP SIGNATURE-----

--17ExsrJJVvsc15xs--