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 1s6mr7-001lux-AC for pgsql-committers@arkaria.postgresql.org; Tue, 14 May 2024 07:45:50 +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 1s6mr7-00Ax3K-Dg for pgsql-committers@arkaria.postgresql.org; Tue, 14 May 2024 07:45:49 +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.94.2) (envelope-from ) id 1s6cjf-005Uvh-0U for pgsql-committers@lists.postgresql.org; Mon, 13 May 2024 20:57:27 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s6cjX-0004M7-9D for pgsql-committers@lists.postgresql.org; Mon, 13 May 2024 20:57:26 +0000 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=postgresql.org; s=20171124; h=Date:Message-Id:Subject:To:From:MIME-Version: Content-Type:Sender:Reply-To:Cc:Content-Transfer-Encoding:Content-ID: Content-Description:In-Reply-To:References; bh=ePBWadtg0UvQQ02b82b0ilcxuvPVHCFmTapf93/W8Yw=; b=ps3Y82z4gWm76uIw1eqAKTchkm c/Of9coHzNi41SUHKZOJwOc4oZr2vXfnci+zj3SHFrw796W6w3lXkZjTn4gXpEmf095JkIKVzbgww F05jK8NAGq6j34mY2meGcu9D7BIhK8XBH0hLza4nknDPCHhav8qlb6IuMCtSqqX+VNpd3R0iNE824 62mGikyLLhBCYyV/A/pFGtOVTWfSh6+LEnVIkDs8js0lZzUNLww1c/7GzRSRUa5XataeJ7F3dQyA7 B/kvyeqfllNGFzx02T/bfl+LwCs+yhO+PkWTBGJ3U87Hfx/HOuaCQG2+cvK62kgYpM4P3bWjppf7w kwSVAc4g==; Received: from gemulon.postgresql.org ([2001:4800:3e1:1::198]) by mahout.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s6cjV-0009u7-Rk for pgsql-committers@lists.postgresql.org; Mon, 13 May 2024 20:57:17 +0000 Received: from localhost ([127.0.0.1] helo=gemulon.postgresql.org) by gemulon.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1s6cjV-0003mf-7c for pgsql-committers@lists.postgresql.org; Mon, 13 May 2024 20:57:17 +0000 Content-Type: multipart/mixed; boundary="===============1725312700987738597==" MIME-Version: 1.0 From: Nathan Bossart To: pgsql-committers@lists.postgresql.org Subject: pgsql: Fix pg_sequence_last_value() for unlogged sequences on standbys. X-Auto-Response-Suppress: All Auto-Submitted: auto-generated Message-Id: Date: Mon, 13 May 2024 20:57:17 +0000 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --===============1725312700987738597== Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: base64 Rml4IHBnX3NlcXVlbmNlX2xhc3RfdmFsdWUoKSBmb3IgdW5sb2dnZWQgc2VxdWVuY2VzIG9uIHN0 YW5kYnlzLgoKUHJlc2VudGx5LCB3aGVuIHRoaXMgZnVuY3Rpb24gaXMgY2FsbGVkIGZvciBhbiB1 bmxvZ2dlZCBzZXF1ZW5jZSBvbgphIHN0YW5kYnkgc2VydmVyLCBpdCB3aWxsIGVycm9yIG91dCB3 aXRoIGEgbWVzc2FnZSBsaWtlCgogICAgICAgIEVSUk9SOiAgY291bGQgbm90IG9wZW4gZmlsZSAi YmFzZS81LzE2Mzg4IjogTm8gc3VjaCBmaWxlIG9yIGRpcmVjdG9yeQoKU2luY2UgdGhlIHBnX3Nl cXVlbmNlcyBzeXN0ZW0gdmlldyB1c2VzIHBnX3NlcXVlbmNlX2xhc3RfdmFsdWUoKSwKaXQgY2Fu IGVycm9yIHNpbWlsYXJseS4gIFRvIGZpeCwgbW9kaWZ5IHRoZSBmdW5jdGlvbiB0byByZXR1cm4g TlVMTApmb3IgdW5sb2dnZWQgc2VxdWVuY2VzIG9uIHN0YW5kYnkgc2VydmVycy4gIFNpbmNlIHRo aXMgYnVnIGlzCnByZXNlbnQgb24gYWxsIHZlcnNpb25zIHNpbmNlIHYxNSwgdGhpcyBhcHByb2Fj aCBpcyBwcmVmZXJhYmxlIHRvCm1ha2luZyB0aGUgRVJST1IgbmljZXIgYmVjYXVzZSB3ZSBuZWVk IHRvIHJlcGFpciB0aGUgcGdfc2VxdWVuY2VzCnZpZXcgd2l0aG91dCBtb2RpZnlpbmcgaXRzIGRl ZmluaXRpb24gb24gcmVsZWFzZWQgdmVyc2lvbnMuICBGb3IKY29uc2lzdGVuY3ksIHRoaXMgY29t bWl0IGFsc28gbW9kaWZpZXMgdGhlIGZ1bmN0aW9uIHRvIHJldHVybiBOVUxMCmZvciBvdGhlciBz ZXNzaW9ucycgdGVtcG9yYXJ5IHNlcXVlbmNlcy4gIFRoZSBwZ19zZXF1ZW5jZXMgdmlldwphbHJl YWR5IGFwcHJvcHJpYXRlbHkgZmlsdGVycyBvdXQgc3VjaCBzZXF1ZW5jZXMsIHNvIHRoZXJlJ3Mg bm8gYnVnCnRoZXJlLCBidXQgd2UgbWlnaHQgYXMgd2VsbCBvZmZlciBzb21lIGRlZmVuc2UgaW4g Y2FzZSBzb21lb25lCmludm9rZXMgdGhpcyBmdW5jdGlvbiBkaXJlY3RseS4KClVubG9nZ2VkIHNl cXVlbmNlcyB3ZXJlIGZpcnN0IGludHJvZHVjZWQgaW4gdjE1LCBidXQgdGVtcG9yYXJ5CnNlcXVl bmNlcyBhcmUgbXVjaCBvbGRlciwgc28gd2hpbGUgdGhlIGZpeCBmb3IgdW5sb2dnZWQgc2VxdWVu Y2VzCmlzIG9ubHkgYmFjay1wYXRjaGVkIHRvIHYxNSwgdGhlIHRlbXBvcmFyeSBzZXF1ZW5jZSBw b3J0aW9uIGlzCmJhY2stcGF0Y2hlZCB0byBhbGwgc3VwcG9ydGVkIHZlcnNpb25zLgoKV2UgY291 bGQgYWxzbyByZW1vdmUgdGhlIHByaXZpbGVnZSBjaGVjayBpbiB0aGUgcGdfc2VxdWVuY2VzIHZp ZXcKZGVmaW5pdGlvbiBpbiB2MTggaWYgd2UgbW9kaWZ5IHRoaXMgZnVuY3Rpb24gdG8gcmV0dXJu IE5VTEwgZm9yCnNlcXVlbmNlcyBmb3Igd2hpY2ggdGhlIGN1cnJlbnQgdXNlciBsYWNrcyBwcml2 aWxlZ2VzLCBidXQgdGhhdCBpcwpsZWZ0IGFzIGEgZnV0dXJlIGV4ZXJjaXNlIGZvciB3aGVuIHYx OCBkZXZlbG9wbWVudCBiZWdpbnMuCgpSZXZpZXdlZC1ieTogVG9tIExhbmUsIE1pY2hhZWwgUGFx dWllcgpEaXNjdXNzaW9uOiBodHRwczovL3Bvc3Rnci5lcy9tLzIwMjQwNTAxMDA1NzMwLkdBNTk0 NjY2JTQwbmF0aGFueHBzMTMKQmFja3BhdGNoLXRocm91Z2g6IDEyCgpCcmFuY2gKLS0tLS0tClJF TF8xNF9TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9w Zy9jb21taXRkaWZmL2M4NzE0MjMwYWQzNWNjNDU4NzU1NWViZTcwNTJiYTBlYzg3NzIyZjAKCk1v ZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3NlcXVlbmNl LmMgfCAyNyArKysrKysrKysrKysrKysrKystLS0tLS0tLS0KMSBmaWxlIGNoYW5nZWQsIDE4IGlu c2VydGlvbnMoKyksIDkgZGVsZXRpb25zKC0pCgo= --===============1725312700987738597==--