[email protected] writes:
> Attached is v2, which takes the opposite approach: instead of teaching
> the deparser to avoid the constructs, it gives every construct that
> resolves an operator by unqualified name a place to write a
> schema-qualified one. That covers the full list you cataloged back in
> 2018 ([email protected]) -- IS [NOT] DISTINCT FROM,
> NULLIF, simple CASE, row comparisons, ANY/ALL subquery comparisons --
> plus JOIN USING / NATURAL JOIN, which has the same disease.
I didn't read the patch yet, but this sounds promising.
> If the direction looks right I will register this in the next
> commitfest (PG 20-1).
Next one is already 20-2, but please do register it.
regards, tom lane