On Fri, Jul 1, 2022 at 6:40 AM Tom Lane <t...@sss.pgh.pa.us> wrote: > Robert Haas <robertmh...@gmail.com> writes: > > What would probably help more is adding something like this to the > > error message: > > HINT: column "b" could refer to any of these relations: "foo", "excluded" > > +1, that seems like it could be handy across the board.
The user *will* get a similar HINT if they happen to *also* spell the would-be ambiguous column name slightly incorrectly: ERROR: column "barr" does not exist LINE 1: ...lict (bar) do update set bar = excluded.bar where barr != 5; ^ HINT: Perhaps you meant to reference the column "foo.bar" or the column "excluded.bar". -- Peter Geoghegan