ALTER DATABASE SET not working as expected?

From: Tim Uckun <timuckun(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: ALTER DATABASE SET not working as expected?
Date: 2021-09-09 07:52:51
Message-ID: CAGuHJrM+cSk+QhmuAMgw59t5nEcHXLCpQ1jErbab+=c5FMuP6A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ian Lawrence Barwick 2021-09-09 09:06:08 Re: ALTER DATABASE SET not working as expected?
Previous Message Abhishek Bhola 2021-09-09 07:06:25 Re: Postgresql 11: terminating walsender process due to replication timeout