Function `set_config` doesn't work in with query? - Mailing list pgsql-general

From Zexuan Luo
Subject Function `set_config` doesn't work in with query?
Date
Msg-id CAADJU12T-Zxuah=3+821YjyL5M9_r-Cmvyjp2VWSjGVrWisjEQ@mail.gmail.com
Whole thread Raw
Responses Re: Function `set_config` doesn't work in with query?  (Rene Romero Benavides <rene.romero.b@gmail.com>)
Re: Function `set_config` doesn't work in with query?  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-general
For instance:
```
with t as (
    select set_config('blah', '1', false)
)
    select current_setting('blah');
select current_setting('blah');
```

Execute queries above gets these error messages:
psql:test-query-dump.sql:4: ERROR:  unrecognized configuration parameter "blah"
psql:test-query-dump.sql:5: ERROR:  unrecognized configuration parameter "blah"

Thank you for any responses.


pgsql-general by date:

Previous
From: Jack LIU
Date:
Subject: SPI Interface to Call Procedure with Transaction Control Statements
Next
From: Rene Romero Benavides
Date:
Subject: Re: Function `set_config` doesn't work in with query?