Postgres Pro
Downloads
Home   >   mailing lists

Re: ALTER DATABASE SET not working as expected? - Mailing list pgsql-general

From Ian Lawrence Barwick
Subject Re: ALTER DATABASE SET not working as expected?
Date
Msg-id CAB8KJ=jdjZb01nazKDF_9i+iXcf0RFhgLLQpEjm9E3u6uE=rXg@mail.gmail.com
Whole thread Raw
In response to ALTER DATABASE SET not working as expected?  (Tim Uckun <timuckun@gmail.com>)
Responses Re: ALTER DATABASE SET not working as expected?  (Tim Uckun <timuckun@gmail.com>)
List pgsql-general
Tree view 
2021年9月9日(木) 16:53 Tim Uckun <timuckun@gmail.com>:
>
> This seems simple enough but it's not working.
>
> alter database dbname  set "blah.blah" = 'test_value' ;
>
> The above statement returns with no errors.
>
> select current_setting('blah.blah')
>
> The above statement returns a record with null

Open a new database session and you should see the setting.

> Also how long does the "ALTER DATABASE SET" last? Will it survive a
> shutdown and restart?

Yes.


Regards

Ian Barwick

--
EnterpriseDB: https://www.enterprisedb.com

pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: ALTER DATABASE SET not working as expected?
Next
From: Simon Riggs
Date:
Subject: Re: Subscriber to Get Only Some of The Tables From Publisher