Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
A PostgreSQL minor bug when using a SET LOCAL guc
select current_setting('response.smth', true) is null; -- gives true
begin;
set local "response.smth" = 'value';
commit; -- or rollback
select current_setting('response.smth', true) is null; -- gives false since current_setting('response.smth') now is equal to ''
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.