Re: Possible trigger bug? function call argument literalised

Quoting Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>:

> Thiemo Kellner <thiemo(at)gelassene-pferde(dot)biz> writes:
>> create trigger CALCULATION_METHOD_BR_IU
>> before insert on CALCULATION_METHOD
>> for each row
>> execute function METHOD_CHECK(current_schema);
>
>> Executing such, the string "current_schema" gets literalised, i.e.
>> single quoted:
>
> Yup, per the CREATE TRIGGER documentation [1]:
>
> arguments
>
> An optional comma-separated list of arguments to be provided to the
> function when the trigger is executed. The arguments are literal
> string constants. Simple names and numeric constants can be written
> here, too, but they will all be converted to strings. Please check the
> description of the implementation language of the trigger function to
> find out how these arguments can be accessed within the function; it
> might be different from normal function arguments.
>
>> I strongly feel this is a bug,
>
> It's operating as designed. There might be scope for a feature
> improvement here, but it'd be a far-from-trivial task, with probably
> a lot of ensuing compatibility breakage.
>

Oh, thanks! I did not read careful enough. I could not imagine such a
behaviour to be intentional.

Well, I guess, I can put the correct schema at installation, but would
have liked to have a more general approach. Furthermore, I think this
also implies that installation can only be done by psql. :-s

--
S/MIME Public Key: https://oc.gelassene-pferde.biz/index.php/s/eJuAUFONag6ofnH
Signal (Safer than WhatsApp): +49 1578 7723737
Threema (Safer than WhatsApp): A76MKH3J
Handys: +41 78 947 36 21 | +49 1578 772 37 37