Horton

Re: Document transition table triggers are not allowed on views/foreign tables

Etsuro Fujita <etsuro.fujita@gmail.com>

View thread View on postgr.es
From: Etsuro Fujita <etsuro.fujita@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2025-07-23T10:45:42Z
Lists: pgsql-hackers 
On Tue, Jul 15, 2025 at 4:55 PM Etsuro Fujita <etsuro.fujita@gmail.com> wrote:
> Another thing I noticed about transition tables is that while we
> prohibit transition tables on views/foreign tables, there is no
> description about that in the user-facing documentation.  So I would
> like to propose to do $SUBJECT in create_trigger.sgml.  Attached is a
> patch for that.

If there are no objections, I will push this and back-patch it to all
supported versions.

Best regards,
Etsuro Fujita

Commits

  1. Doc: clarify the restrictions of AFTER triggers with transition tables.