Request a Demo
Home   >   mailing lists

Re: BUG #19064: Trigger allows creation with invalid column references but fails at runtime - Mailing list pgsql-bugs

From David G. Johnston
Subject Re: BUG #19064: Trigger allows creation with invalid column references but fails at runtime
Date
Msg-id CAKFQuwYX2UNBngm2Qce+aA=4kc-OBsccNaRvvBoQ2disCyXFMg@mail.gmail.com
Whole thread Raw
In response to BUG #19064: Trigger allows creation with invalid column references but fails at runtime  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
Tree view
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.

pgsql-bugs by date:

Previous
From: Todd Cook
Date:
Subject: Re: Postgres: Queries are too slow after upgrading to PG17 from PG15
Next
From: Rahila Syed
Date:
Subject: Re: BUG #19064: Trigger allows creation with invalid column references but fails at runtime