Horton

[16] ALTER SUBSCRIPTION ... SET (run_as_owner = ...) is a no-op

Jeff Davis <pgsql@j-davis.com>

View thread View on postgr.es
From: Jeff Davis <pgsql@j-davis.com>
To: pgsql-bugs@postgresql.org
Cc: Robert Haas <robertmhaas@gmail.com>
Date: 2023-09-09T20:42:46Z
Lists: pgsql-bugs 
Repro:
  ALTER SUBSCRIPTION s1 SET (run_as_owner = true);
  SELECT subrunasowner FROM pg_subscription WHERE subname='s1';
   subrunasowner 
  ---------------
   f
  (1 row)

It also looks like a change to that field may not cause the
subscription worker to restart. It would be good to add a test for that
case.

Regards,
	Jeff Davis

Commits

  1. Fix the ALTER SUBSCRIPTION to reflect the change in run_as_owner option.