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.
>
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 |