Tom Lane wrote:
> Guy Rouillier <guyr-ml1@burntmail.com> writes:
>> I set that up, and using the SHOW command returns the set value. I
>> searched the archives and I couldn't identify a way to retrieve these
>> values in a trigger function.
>
> http://www.postgresql.org/docs/8.2/static/functions-admin.html#FUNCTIONS-ADMIN-SET-TABLE
>
Thank you, Tom. Since "select current_setting('uservars.user_name')"
and "SHOW uservars.user_name" are both PostgreSQL extensions, why not
allow them to be used interchangeably? In short, why isn't the
following legal in a PL/pgsql procedure:
NEW.user_name := (SHOW uservars.user_name);
--
Guy Rouillier