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.94.2) (envelope-from ) id 1t5fiv-007bh7-Nj for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Oct 2024 06:29:02 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1t5fiu-00D1mT-28 for pgsql-hackers@arkaria.postgresql.org; Tue, 29 Oct 2024 06:29:00 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t5fis-00D1g5-Ib for pgsql-hackers@lists.postgresql.org; Tue, 29 Oct 2024 06:29:00 +0000 Received: from fhigh-a1-smtp.messagingengine.com ([103.168.172.152]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1t5fip-003Oer-S0; Tue, 29 Oct 2024 06:28:57 +0000 Received: from phl-compute-04.internal (phl-compute-04.phl.internal [10.202.2.44]) by mailfhigh.phl.internal (Postfix) with ESMTP id 1B46C11400FD; Tue, 29 Oct 2024 02:28:54 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-04.internal (MEProxy); Tue, 29 Oct 2024 02:28:54 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eisentraut.org; h=cc:cc:content-transfer-encoding:content-type:content-type :date:date:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:subject:subject:to:to; s=fm2; t=1730183334; x=1730269734; bh=v36GCTgGnI0g5d77nSduNq4ddRBWxzq0 gS3LBtsfRP4=; b=EXbpt9fJJedRvFVljS+Nmf/WYbo7YCvLhWXV71b7qgkG/PKa GCLYWtjYmhWcPX97sVnjcS+tquPHzqAp0PFGTCHlWvxGvs99eUqJ3iijh6fLw/Bw gUtYdAwvLBvTiNT4WSle1KFl3m1r6N0IH1VdJgCdV6SNWr7kkDxEAvyUzDSKGn9f KCgFtWi2fRJdhqFsvtVcqhvzeJvoPbqndMqUC1n2i7/6i4dP2olTGreHkh754mF7 LPQ3QakxHnmSBQEWRMJ+ztl6TLD6uyJciExYnwYKoORyH/R7CnR/wGNik0s+UPPg +U8ZhBkyGJZapfqnL2afy7lUBrTBinskoVTCUA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1730183334; x= 1730269734; bh=v36GCTgGnI0g5d77nSduNq4ddRBWxzq0gS3LBtsfRP4=; b=A 7N66GYZT9plgcmqfrMWH9uHvGcFUWW26UT6ZYiJjUP+6SqMJROVkNUW0h1XZS/8b 2Z27CYZ7xMO8pTSUZYknP13KtQuhRqNx7BH74gg4sTVSqZKijaHfm/srKgLp6ztn kD6skXpsLZxpYuhRSKRUIsJaTX3LpM/WAXR1KZXrICVVWW5W6S6uBvkNmx8F2CSN KJslImd39XAzpQh6gcxaSOKR9/+v/oP4sU4QKDGd6pvDN3LE0YRCVbfrRYK4OZmN MiLM5cdg54bz1dIc0Rkf/Y4/3yPZtU2GXhl8BJybo/ZlvTLSDKhZx86dWNoTaGH0 m4IHxLdoYgDUBFv1m8Nsg== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeftddrvdektddgleegucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdggtfgfnhhsuhgsshgtrhhisggvpdfu rfetoffkrfgpnffqhgenuceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnh htshculddquddttddmnecujfgurhepkfffgggfuffvvehfhfgjtgfgsehtjeertddtvdej necuhfhrohhmpefrvghtvghrucfgihhsvghnthhrrghuthcuoehpvghtvghrsegvihhsvg hnthhrrghuthdrohhrgheqnecuggftrfgrthhtvghrnhepgfejtdfhkeeftdeugfeileeh teeljeeghfeuledthfeutedvffdukeefjefhgeehnecuvehluhhsthgvrhfuihiivgeptd enucfrrghrrghmpehmrghilhhfrhhomhepphgvthgvrhesvghishgvnhhtrhgruhhtrdho rhhgpdhnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpohhuthdprhgtphhtthhope hishhhihhisehpohhsthhgrhgvshhqlhdrohhrghdprhgtphhtthhopehpghhsqhhlqdhh rggtkhgvrhhssehpohhsthhgrhgvshhqlhdrohhrgh X-ME-Proxy: Feedback-ID: ie0a040ee:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 29 Oct 2024 02:28:53 -0400 (EDT) Message-ID: Date: Tue, 29 Oct 2024 07:28:51 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: protocol-level wait-for-LSN To: Tatsuo Ishii Cc: pgsql-hackers@postgresql.org References: <8e6ba982-fd41-4779-8729-eb120df69ea0@eisentraut.org> <20241029.140600.1382327295267983604.ishii@postgresql.org> Content-Language: en-US From: Peter Eisentraut In-Reply-To: <20241029.140600.1382327295267983604.ishii@postgresql.org> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 29.10.24 06:06, Tatsuo Ishii wrote: >> The patch adds a protocol extension called _pq_.wait_for_lsn as well >> as a libpq connection option wait_for_lsn to activate the same. (Use >> e.g., psql -d 'wait_for_lsn=1'.) >> >> With this protocol extension, two things are changed: >> >> - The ReadyForQuery message sends back the current LSN. > > If other protocol extension X tries to add something to the > ReadyForQuery message too, what would happen? I think one would have to define that somehow. If it's useful, the additional fields of both extensions could be appended, in some defined order. But this is an interesting question to think about.