8e7ba9b33d
* Enable running pg scripts with datatable database input * Postgres triggers for data tables * REPLICATION attribute on custom_instance_user * disable edit for datatables * Update backend/windmill-trigger-postgres/src/replication_message.rs Co-authored-by: claude[bot] <209825114+claude[bot]@users.noreply.github.com> --------- Co-authored-by: claude[bot] <209825114+claude[bot]@users.noreply.github.com>
11 lines
278 B
SQL
11 lines
278 B
SQL
DO $$
|
|
BEGIN
|
|
IF EXISTS (SELECT 1 FROM pg_roles WHERE rolname = 'custom_instance_user') THEN
|
|
ALTER ROLE custom_instance_user REPLICATION;
|
|
END IF;
|
|
EXCEPTION
|
|
WHEN others THEN
|
|
RAISE NOTICE 'Error granting REPLICATION to custom_instance_user: %', SQLERRM;
|
|
END
|
|
$$;
|