Re: permanent setting of config variables

2021-02-18 Thread Joao Miguel Ferreira
Hi, On Thu, Feb 18, 2021 at 4:05 PM Joe Conway wrote: > On 2/18/21 4:09 AM, 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

Re: permanent setting of config variables

2021-02-18 Thread Joe Conway
On 2/18/21 4:09 AM, 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

Re: permanent setting of config variables

2021-02-18 Thread Laurenz Albe
On Thu, 2021-02-18 at 11:42 +, Joao Miguel Ferreira wrote: > On Thu, Feb 18, 2021 at 10:52 AM Laurenz Albe > wrote: > > On Thu, 2021-02-18 at 09:09 +, Joao Miguel Ferreira wrote: > > > I have a few PL/pgSQL functions that use queires like "SHOW > > > company.product INTO _product_name" a

Re: permanent setting of config variables

2021-02-18 Thread Joao Miguel Ferreira
Hi, On Thu, Feb 18, 2021 at 10:52 AM Laurenz Albe wrote: > On Thu, 2021-02-18 at 09:09 +, 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 fa

Re: permanent setting of config variables

2021-02-18 Thread Laurenz Albe
On Thu, 2021-02-18 at 09:09 +, 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

permanent setting of config variables

2021-02-18 Thread Joao Miguel Ferreira
Hi, 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 "ALTE