Postgres Pro
Downloads
Home   >   mailing lists

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

From Tim Uckun
Subject ALTER DATABASE SET not working as expected?
Date
Msg-id CAGuHJrM+cSk+QhmuAMgw59t5nEcHXLCpQ1jErbab+=c5FMuP6A@mail.gmail.com
Whole thread Raw
Responses Re: ALTER DATABASE SET not working as expected?  (Ian Lawrence Barwick <barwick@gmail.com>)
List pgsql-general
Tree view 
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

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

pgsql-general by date:

Previous
From: Abhishek Bhola
Date:
Subject: Re: Postgresql 11: terminating walsender process due to replication timeout
Next
From: Ian Lawrence Barwick
Date:
Subject: Re: ALTER DATABASE SET not working as expected?