Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wZwqh-001QPq-1U for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Jun 2026 20:26:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wZwqg-007YVr-16 for pgsql-hackers@arkaria.postgresql.org; Wed, 17 Jun 2026 20:26:58 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1wZwqf-007YVS-31 for pgsql-hackers@lists.postgresql.org; Wed, 17 Jun 2026 20:26:58 +0000 Received: from mail-oo1-xc32.google.com ([2607:f8b0:4864:20::c32]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1wZwqd-00000000yNJ-2qth for pgsql-hackers@postgresql.org; Wed, 17 Jun 2026 20:26:57 +0000 Received: by mail-oo1-xc32.google.com with SMTP id 006d021491bc7-69d862236ddso176807eaf.0 for ; Wed, 17 Jun 2026 13:26:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=j-davis-com.20251104.gappssmtp.com; s=20251104; t=1781728013; x=1782332813; darn=postgresql.org; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject :date:message-id:reply-to; bh=AuLa4BjWV46rsgxj1XYkvv2ljSCimJpHR7FSo5Ff/2M=; b=xN4Uep2tBTvqaxMOrleCFDfhp/aPhJZrqNl8BeOa3Nj4FrnisQlnBx2tNfqSTYGZ7i naYsr8IBgkMLtD+PraDQCLNuhXUrMFP3H9Hq6jAnl1ST0yjZYdfvgYiwFu4pEF+0CrJ4 5ZfS4D8TLVXoyrTfA4ZBqsHchALXNkl1KTJvvSrT1ubfPi3kM8eiplMsKlagoh6uurHq fcJa9xFUxDvy54XY5nQmO23rLs+ULzkj9YyfT7JZT/uJHEu/TAc/kR21uZD3B6qx1Dbw Ngo5Cb46KQd/FvJHCfVNAN5vW5jkOLmpwy6Yq/nPk4mnIWpfTmXmQOG6RrAtLt2Ld0Hb 9exA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1781728013; x=1782332813; h=mime-version:user-agent:content-transfer-encoding:references :in-reply-to:date:cc:to:from:subject:message-id:x-gm-gg :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=AuLa4BjWV46rsgxj1XYkvv2ljSCimJpHR7FSo5Ff/2M=; b=a8kK04FQgEBNyT+IuIVvV3RnxibztXS3iKNPxa4973/dMeJfZDVdDyMhFmTJLmqLej bzphulkHOvKxfBXTSDB+UDV8OwnbCxobGrXcIoiO1tzdXQsrSP2mFwjMwgK4ymLX47L0 iyLVMEuTM7yQ468/CB9EG2wjM3NmhtGp+95WfDhfwX2LAxWj3clWyv/bsOACoWLXBvq8 nKqPqqrEbYPn5R/Gb86EHmn2m1Rp9JV7vRUDh5KuVXaSOJ6NWTTfH1EBnd9qVehbsw0B MqOW1RERDwICuwIP0mhPv8+v3uE1PAYX6UWqOhgkcfLTO0mjyrlVOOxGsGc3FGVvlYgw SF2A== X-Gm-Message-State: AOJu0YxWVEXSVAoUVNStcEReAazKNTRQr3Wk9Z11Xy525Flp1M4KUFBP lrB8hj2xYl+7Asi3NjvbFb1szYmK9O36bx1Tbm03lQTnKFxMc/xwRU6+TsTqA6eV2g== X-Gm-Gg: Acq92OFEVmMkPCvEKVBJ5THE2lt5Jc+t03JjOtQoQ3STT5Y7PUUU/aMDmVexq7IRdBc LG7JW2UBTf5A9OZ5u71Jsby4kk6hCYmz2yG0RXwsmJY/xkwHbg05EiYJn9vIG/6LdECXFGlnDhd DEPBptQVxzIzpzpTG/QZXdoixta9xP/pZl/IrplRxcEUcbtLM7KVh016maF+8DSDSy+vPemlGJi vOZFuleRjXu7l0XgGgVaBVw8nN5Qa7nWYA1w4zeBnQoaD+KfRUHwzDMniTkT25YL2U4KcNNF1JR 75LiQnyuLYFKj7ElShAuxN6rnkV4XIJUzIyw0yLfFwyhNeBjGGvdo+nWnAHK0Vw0RMrcrJJTjMU JmHlMmvH5ZyhvXevjgqeCnW0XUbiA/LkiOc9SkJn/jEfTTEABlTejLJHrhBnGJzR8MO1CLnnycx Bcrf9/XiplUhTgTnYTsrZcwDA= X-Received: by 2002:a05:6820:80c8:b0:69e:4008:13e4 with SMTP id 006d021491bc7-6a0c75f70a9mr764746eaf.17.1781728013636; Wed, 17 Jun 2026 13:26:53 -0700 (PDT) Received: from [10.10.244.130] ([12.63.242.123]) by smtp.gmail.com with ESMTPSA id 006d021491bc7-69f00ed975asm7425351eaf.10.2026.06.17.13.26.52 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 17 Jun 2026 13:26:53 -0700 (PDT) Message-ID: Subject: Re: Bug in ALTER SUBSCRIPTION ... SERVER / ... CONNECTION with broken old server From: Jeff Davis To: "Hayato Kuroda (Fujitsu)" , 'Chao Li' Cc: PostgreSQL-development Date: Wed, 17 Jun 2026 13:26:51 -0700 In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable User-Agent: Evolution 3.52.3-0ubuntu1.1 MIME-Version: 1.0 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk 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