Re: Bug in ALTER SUBSCRIPTION ... SERVER / ... CONNECTION with broken old server

Jeff Davis <pgsql@j-davis.com>

From: Jeff Davis <pgsql@j-davis.com>

To: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>, 'Chao Li' <li.evan.chao@gmail.com>

Cc: PostgreSQL-development <pgsql-hackers@postgresql.org>

Date: 2026-06-17T20:26:51Z

Lists: pgsql-hackers

On Wed, 2026-04-22 at 12:35 +0000, Hayato Kuroda (Fujitsu) wrote:
> Before deep dive to your fix, I'm unclear why dropping the active
> USER MAPPING is
> allowed. Personally, it should be avoided anyway. Do you know why
> it's not restricted?

We don't record dependencies on user mappings because technically it's
not dependent on a specific user mapping. That is, GetUserMapping() can
fall back to the public user mapping.

Regards,
	Jeff Davis

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Avoid errors during DROP SUBSCRIPTION when slot_name is NONE.
- 702e9dfd6c50 19 (unreleased) landed
Avoid errors during ALTER SUBSCRIPTION.
- e5c40584a712 19 (unreleased) landed
Check retain_dead_tuples for ALTER SUBSCRIPTION ... SERVER.
- 8eba2edb8010 19 (unreleased) landed
Allow multiple xacts during table sync in logical replication.
- ce0fdbfe9722 14.0 cited