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