Re: permanent setting of config variables

Hi,

On Thu, Feb 18, 2021 at 10:52 AM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> On Thu, 2021-02-18 at 09:09 +0000, Joao Miguel Ferreira wrote:
> > I have a few PL/pgSQL functions that use queires like "SHOW
> company.product INTO _product_name" and "SHOW company.cluster INTO
> _cluster_number".
> > But these are failing because I don't know how to set those values on a
> permanent basis, or maybe on startup would also be ok.
> > I did read the "ALTER DATABASE " and the "set_config(...)" documentation
> and I experimented a bit with that but without succes.
> > So my question would be: how to permanently set user specific config
> values that would become accessible to the "SHOW ...." SQL comand.
>
> _product_name := current_setting('company.product');
>
>
I can not change the code in those functions. I need to make them work as
they are.

So I guess I need to set those variables from an administration action
rather than from a coding action.

Something like "ALTER SYSTEM SET company.procut TO 'SpaceCraft';" but this
returns an error saying "ERROR: unrecognized configuration parameter
"company.procut". If I'm not mistaken, the "SET ...." command lasts only
for the duration of a client session. I need it to be permanent.

> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com
>
>