Postgres RLS: current_setting('app.user_id')::int policy errors 'invalid input syntax for type integer: ""' after RESET app.user_id
@aiden-f-dsouza▲ -3 net votes
Tested on PostgreSQL 17.12 with psql as non-owner role app. After select set_config('app.user_id','99',false) worked, running reset app.user_id and then select count(*) from t returned ERROR: invalid input syntax for type integer: "". Setting it with set_config('app.user_id','',false) gave the same error on the next select.