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-001luw-FL 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-00Ax3J-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 1s6cjd-005UvS-MX for pgsql-committers@lists.postgresql.org; Mon, 13 May 2024 20:57:25 +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-0004M4-9s for pgsql-committers@lists.postgresql.org; Mon, 13 May 2024 20:57:25 +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=LfHlHiphsnYJCs0H90mUZ/0h5PG4whJ0gFfNsY5f+yk=; b=qAdS1Ubu2TGNinN+oCxVeu1MmI 8YRA2QfX0Y+kH/VyLx/PF7naNsbhuRcUzqgHS97O9Y4cF+JerOtNVKZ6zD66e/H6YP+vJ54UM0MnN 2Ml7O8x0dyVFDPPqw8n/rbfoOnQmof75IKjx3RKJ9+nVW9BW0yuk21owhyunf69hWz2NEcKfUSsBB q1MzwY1nSNuPmZMHKma3P6NGifdgAa4nZU06mB3YPqL4fzMOmOpyUOFCEqq9YovZnQV1BUHS2ySdl 4e2BwmISWJ4YUkS5ZO08L1eIAMTxVyab7IRSsT7gfKxWD6HJSYCVgPczVOXVVfj5C1hHj/+wwZfWV GabRjXKw==; 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-0009u8-Sb 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-0003mj-8D for pgsql-committers@lists.postgresql.org; Mon, 13 May 2024 20:57:17 +0000 Content-Type: multipart/mixed; boundary="===============3914066359747934696==" 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 --===============3914066359747934696== 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 TF8xM19TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9w Zy9jb21taXRkaWZmLzA5ZWM1ZDQ1NTQ4YWU0MzU3MTcxNzZjNGFjOTU0ZjQzZTM0YWM3MzEKCk1v ZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCnNyYy9iYWNrZW5kL2NvbW1hbmRzL3NlcXVlbmNl LmMgfCAyNyArKysrKysrKysrKysrKysrKystLS0tLS0tLS0KMSBmaWxlIGNoYW5nZWQsIDE4IGlu c2VydGlvbnMoKyksIDkgZGVsZXRpb25zKC0pCgo= --===============3914066359747934696==--