On Mon, 2023-10-23 at 08:35 -0700, David G. Johnston wrote:
> I tend to prefer the argument that these views are for human consumption and should
> be designed with that in mind.
True, although given the shape of ACLs, it takes a somewhat trained human to
consume the string representation. But we won't be able to hide the fact that
default ACLs are NULL in the catalogs. We can leave them empty, we can show
them as "(default)" or we can let the user choose with "\pset null".
> I would suggest that we make the expected presence of NULL as an input explicit:
> I would offer up:
>
> when spcacl is null then '(default)'
Noted.
> along with not translating (none) and (default) and thus making the data contents
> of these views environment independent. But minimizing the variance of these command's
> output across systems doesn't seem like a design goal that is likely to gain consensus
> and is excessive when viewed within the framework of these being only for human consumption.
I didn't understand this completely. You want default privileges displayed as
"(default)", but are you for or against "\pset null" to have its normal effect on
the output of backslash commands in all other cases?
Speaking of consensus, it seems to me that Tom, Erik and me are in consensus.
Yours,
Laurenz Albe