Peter Eisentraut <peter(dot)eisentraut(at)enterprisedb(dot)com> writes:
> I had to do some analysis on the "sanity" tests in the regression test
> suite (opr_sanity, type_sanity) recently, and I found some of the
> queries very confusing. One main stumbling block is that for some
> probably ancient reason many of the older queries are written with
> correlation names p1, p2, etc. independent of the name of the catalog.
I think that was at least partially my fault, and no there isn't
any very good reason for it. Your proposal seems fine.
regards, tom lane