Re: Transition relation clarification - Mailing list pgsql-docs

From David G. Johnston
Subject Re: Transition relation clarification
Date
Msg-id CAKFQuwasvmo816dz=fyqbMHLMcEj8KBWa=cguaSXqqiXHT=6Xw@mail.gmail.com
Whole thread Raw
In response to Transition relation clarification  (Dull Bananas <dull.bananas0@gmail.com>)
Responses Re: Transition relation clarification
List pgsql-docs
On Mon, Jan 1, 2024 at 9:35 AM Dull Bananas <dull.bananas0@gmail.com> wrote:
The docs should mention that transition relations aren't automatically made available in functions called by the trigger function. This unknown behavior caused a lot of frustration for me.

Seems to fall into the "if it isn't documented it doesn't happen" category of things that we simply choose not to clutter the documentation with.  Called functions don't inherit stuff from the caller.  It is like documenting a variable in the calling function isn't visible to the called function.  Admittedly at least with variables you can pass them via arguments.  The special trigger state is indeed available in the trigger returning function when it is the function directly invoked by the trigger.

David J.

pgsql-docs by date:

Previous
From: PG Doc comments form
Date:
Subject: Postgres compilation instructions do not work on modern debian or ubuntu
Next
From: Dull Bananas
Date:
Subject: Re: Transition relation clarification