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

From: Jeff Davis <pgsql(at)j-davis(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: Robert Haas <robertmhaas(at)gmail(dot)com>
Subject: [16] ALTER SUBSCRIPTION ... SET (run_as_owner = ...) is a no-op
Date: 2023-09-09 20:42:46
Message-ID: 17b62714fd115bd1899afd922954540a5c6a0467.camel@j-davis.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2023-09-09 20:54:40 Re: BUG #18101: 'RAISE LOG ...' with omitted trailing ';' does not throw syntax error in certain situations
Previous Message Tom Lane 2023-09-09 19:18:07 Re: BUG #18097: Immutable expression not allowed in generated at