---
--- test functionality of SET/RESET
---


select * from pg_settings where name not in ('config_file','data_directory','hba_file','ident_file') order by name;

SHOW enable_bitmapscan;
BEGIN TRANSACTION;
SET enable_bitmapscan = off;
ROLLBACK;
SHOW enable_bitmapscan;

BEGIN TRANSACTION;
SET enable_bitmapscan = off;
COMMIT;
SHOW enable_bitmapscan;

RESET enable_bitmapscan;
SHOW enable_bitmapscan;