On Thu, 2023-05-11 at 13:09 +0200, Peter Eisentraut wrote:
> There is also the deterministic flag and the icurules setting.
> Depending on what level of detail you imagine the user needs, you
> really
> do need to look at the whole picture, not some subset of it.
(Nit: all database default collations are deterministic.)
I agree, but I think there should be a way to see the whole picture in
one command. If nothing else, for repro cases sent to the list, it
would be nice to have a single line like:
SELECT show_default_collation_whole_picture();
Right now it involves some back and forth, like checking
datlocprovider, then looking in the right fields and ignoring the wrong
ones.
Regards,
Jeff Davis