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

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #19064: Trigger allows creation with invalid column references but fails at runtime
Дата
Msg-id CAKFQuwYX2UNBngm2Qce+aA=4kc-OBsccNaRvvBoQ2disCyXFMg@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #19064: Trigger allows creation with invalid column references but fails at runtime  (PG Bug reporting form <noreply@postgresql.org>)
Список 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.

В списке pgsql-bugs по дате отправления: