Date: Wed, 30 Aug 2023 12:00:30 +0200
From: "Peter J. Holzer" <hjp-pgsql@hjp.at>
To: pgsql-general@lists.postgresql.org
Subject: Re: Restoring default privileges on objects
Message-ID: <20230830100030.oxnegs7cxbzvjizt@hjp.at>
Mail-Followup-To: pgsql-general@lists.postgresql.org
References: <96d6885a-5e25-9ae8-4a1a-d7e557a5fe9c@mtneva.com>
 <1166048641.281962.1693308151542@office.mailbox.org>
 <1006397.1693318485@sss.pgh.pa.us>
 <efdd465d-a795-6188-7f71-7cdb4b2be031@mtneva.com>
 <1550267563.330669.1693335893138@office.mailbox.org>
 <31246.1693337238@sss.pgh.pa.us>
 <e7387e04-0a17-3a77-8e0c-da6794625a30@mtneva.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="jt3btsvbneoldkw4"
Content-Disposition: inline
In-Reply-To: <e7387e04-0a17-3a77-8e0c-da6794625a30@mtneva.com>
Archived-At: <https://www.postgresql.org/message-id/20230830100030.oxnegs7cxbzvjizt%40hjp.at>
Precedence: bulk


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

On 2023-08-29 14:44:48 -0600, Stuart McGraw wrote:
> On 8/29/23 13:27, Tom Lane wrote:
> > Fixing \dp to honor "\pset null" for this might be a reasonable
> > thing to do too.  I'm actually a bit surprised that that doesn't
> > work already.
>=20
> That change would still require someone using \dp to realize that
> the "Access privileges" value could be either '' or NULL (I guess
> that could be pointed out more obviously in the psql doc), and then
> do a '\pset null' before doing \dp?  That seems a little inconvenient.

Or just always do a \pset null. For me printing NULL the same as an
empty string is just as confusing in normal tables, so that's the first
line in my ~/.psqlrc. YMMV, of course.

But I guess the point is that people who do \pset null expect to be able
to distinguish '' and NULL visually and might be surprised if that
doesn't work everywhere, while people who don't \pset null know that ''
and NULL are visually indistinguishable and that they may need some
other way to distinguish them if the difference matters.

So +1 for me fixing \dp to honor "\pset null".

        hp

--=20
   _  | Peter J. Holzer    | Story must make more sense than reality.
|_|_) |                    |
| |   | hjp@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"

--jt3btsvbneoldkw4
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAmTvEzkACgkQ8g5IURL+
KF20ng/9FqxAGlJSmnGgkESuEd0WotNEvQaw/uLQjUX6TM9wbuxWXrRL1ePS3NNG
O9iDhBwgD5m+/QkzoGu47my4hlNUsHQt900tGOCf4C0qKLVeM8nIEH3oFLYuQZzK
IOrD4MmCDVgUwbx1CWnDcYSZQ0bi+4Uuxa9IfNyMxthNqYrNtm50jJ3zpHyhd/Q+
HrOMeXADkA234A9AD7vBPPiQs8oFX5p2NKwxd+AevuAoDDQfsK3LuFGZDc2cyUyb
1vK9fJjNDV+0MhkJqmbVz5manafHur5Hdu2FfvHVNk+/6rwOm4WmXqzOhbJ0dojZ
qXLUaOdKY8lnWqDHROhc+XT5tYWDO+u1tNdcoXedQeWIBQ/TBTZcIGZAaTCVKaX7
S+Eho5oo/70xHCCM50jAH7OOxwmOizEFXX6aJYFuneo4c2jAmQg8OIKIHkPaYUMW
aGWVXEWttUpDPEA60SeHbvMGie1Yp2Edblojf1RQwz/8j6FWrjLnTbVhwZbvprLE
q1bYA7sKio8ZfiNsbWzfz6TC6x18CLDiV0uKFf+RPTGWJb33loDXElC/pSxLf58e
vY7gX+uMc2bpzaL80HfsKj4jOtYmqv0LJ5T/osUELZImSNV4RoxE02HiYkid564l
rhTeqnZ0wHPbAhquS6z0EkP7FQ2UkKgi1UQisOTN+E2F3avfrmo=
=ulGH
-----END PGP SIGNATURE-----

--jt3btsvbneoldkw4--