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 1s6mqE-001lqB-HQ for pgsql-committers@arkaria.postgresql.org; Tue, 14 May 2024 07:44:56 +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 1s6mqE-00AuI6-EX for pgsql-committers@arkaria.postgresql.org; Tue, 14 May 2024 07:44:54 +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 1s6cjY-005Uv1-V2 for pgsql-committers@lists.postgresql.org; Mon, 13 May 2024 20:57:20 +0000 Received: from mahout.postgresql.org ([2001:4800:3e1:1::227]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1s6cjW-0003WQ-Ge for pgsql-committers@lists.postgresql.org; Mon, 13 May 2024 20:57:19 +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=IkP8i/IWlxeSPkJjXvVjarZApszeZjYA+Bdn44SYUZI=; b=mel+Fe2FKOPTTdsp//tsG5PksP s77HV2kQeW0jd6GuxOwuDo/nOs6bxf6FQMIGg4wTl0BjHQ7xJC/WNUEkqMLyJw8BL6fFqVuSeZZ6E ntG55+A4lQuxu2F3VleGEQEWQkFC6zKtVmOO3reWJlDlDUrMlfJiMGTSP6RuU37FvyYd+wLJjt42n Wkd0iITiBqWH8bxP8njYPGLJ/afEod5oRM5rnP78u2F4ic2D6uZHATkWsGukmYDyvShRD2y0Hp0Kw JTxfBHG1aQvZnUfjcjHGTyGiYhU/o4ci+HKVowQuflrEvl+7uVRaDnaOV6Ho0QRjIxTUQnxDxW3r2 /yi18qcQ==; 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-0009u6-Sm 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-0003mc-77 for pgsql-committers@lists.postgresql.org; Mon, 13 May 2024 20:57:17 +0000 Content-Type: multipart/mixed; boundary="===============5881483588102972072==" 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 --===============5881483588102972072== 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 TF8xNV9TVEFCTEUKCkRldGFpbHMKLS0tLS0tLQpodHRwczovL2dpdC5wb3N0Z3Jlc3FsLm9yZy9w Zy9jb21taXRkaWZmLzg1N2QyODBjNjUyODc2ZTBiYmYwZTFiNWMyMzc1NzQ1MTRiNTBlYmMKCk1v ZGlmaWVkIEZpbGVzCi0tLS0tLS0tLS0tLS0tCmRvYy9zcmMvc2dtbC9zeXN0ZW0tdmlld3Muc2dt bCAgICAgICAgfCAyOSArKysrKysrKysrKysrKysrKysrKysrKysrLS0tLQpzcmMvYmFja2VuZC9j b21tYW5kcy9zZXF1ZW5jZS5jICAgICAgIHwgMzEgKysrKysrKysrKysrKysrKysrKysrKy0tLS0t LS0tLQpzcmMvdGVzdC9yZWNvdmVyeS90LzAwMV9zdHJlYW1fcmVwLnBsIHwgIDkgKysrKysrKysr CjMgZmlsZXMgY2hhbmdlZCwgNTYgaW5zZXJ0aW9ucygrKSwgMTMgZGVsZXRpb25zKC0pCgo= --===============5881483588102972072==--