Re: Transition relation clarification

From: Dull Bananas <dull(dot)bananas0(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: pgsql-docs(at)lists(dot)postgresql(dot)org
Subject: Re: Transition relation clarification
Date: 2024-01-01 18:43:35
Message-ID: CAKmgnAhPLHwg3v4FH3t9PHG-xt0pZJHMYnLPrG=4GWCB3Nu=Zw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The documentation is not specific enough about what a transition table is
or what it means to create a transition table, so I assumed that it works
similarly to `CREATE TEMPORARY TABLE`. The existence of variable-like
tables is not documented.

On Mon, Jan 1, 2024 at 10:22 David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>
wrote:

> On Mon, Jan 1, 2024 at 9:35 AM Dull Bananas <dull(dot)bananas0(at)gmail(dot)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.
>

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2024-01-01 19:23:58 Re: Postgres compilation instructions do not work on modern debian or ubuntu
Previous Message David G. Johnston 2024-01-01 17:21:33 Re: Transition relation clarification