Unable to modify pg_net.batch_size
I’m using triggers which are using supabase_functions.http_request.
Under the hood, the function uses the pg_net extension.
At the moment I’m unable to edit the pg_net extension configuration explained here https://github.com/supabase/pg_net?tab=readme-ov-file#extension-configuration
I want to lower the value of pg_net.batch_size which has a default of 200, but following the guide I’m unable to do it because of permission problems.
If I follow the pg_net guide, (the current version of Postgres is >=15) doing:
'grant alter system on parameter pg_net.batch_size to postgres;'
and then doing
'alter system set pg_net.batch_size to 20;'
the second statement fails with:
'SQL Error [42501]: ERROR: permission denied to set parameter "pg_net.batch_size"'
From what I understood, the first grant statement should be supposed to populate the pg_catalog.pg_parameter_acl table, but after the grant is executed it stays empty.
Am I missing something?
Under the hood, the function uses the pg_net extension.
At the moment I’m unable to edit the pg_net extension configuration explained here https://github.com/supabase/pg_net?tab=readme-ov-file#extension-configuration
I want to lower the value of pg_net.batch_size which has a default of 200, but following the guide I’m unable to do it because of permission problems.
If I follow the pg_net guide, (the current version of Postgres is >=15) doing:
'grant alter system on parameter pg_net.batch_size to postgres;'
and then doing
'alter system set pg_net.batch_size to 20;'
the second statement fails with:
'SQL Error [42501]: ERROR: permission denied to set parameter "pg_net.batch_size"'
From what I understood, the first grant statement should be supposed to populate the pg_catalog.pg_parameter_acl table, but after the grant is executed it stays empty.
Am I missing something?
GitHub
A PostgreSQL extension that enables asynchronous (non-blocking) HTTP/HTTPS requests with SQL - GitHub - supabase/pg_net: A PostgreSQL extension that enables asynchronous (non-blocking) HTTP/HTTPS r...
