Re: BUG #19064: Trigger allows creation with invalid column references but fails at runtime

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>

To: "ketan.bhatiya@lenditt.com" <ketan.bhatiya@lenditt.com>, "pgsql-bugs@lists.postgresql.org" <pgsql-bugs@lists.postgresql.org>

Date: 2025-09-26T12:46:03Z

Lists: pgsql-bugs

On Friday, September 26, 2025, PG Bug reporting form <noreply@postgresql.org>
wrote:

> The following bug has been logged on the website:
>
> Bug reference:      19064
> Logged by:          Ketan Bhatiya
> Email address:      ketan.bhatiya@lenditt.com
> PostgreSQL version: Unsupported/Unknown
> Operating system:   Windows
> Description:
>
> Suggestion / Proposed Improvement
> PostgreSQL should validate column references at trigger creation time, not
> just at runtime.
> If a column does not exist in the target table (Orders in this example),
> trigger creation should fail immediately with a clear error message.
>
>
The bug reporting list should not be used for feature requests.  Those
should be directed to -general.

It seems unlikely anyone is going to spend time on this though.  You are
expected to test what you write and this fails immediately and obviously.

David J.