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 1sOKG6-00Df4F-7G for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Jul 2024 16:52:06 +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 1sOKG4-003GSY-K6 for pgsql-hackers@arkaria.postgresql.org; Mon, 01 Jul 2024 16:52:04 +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 1sOKG4-003GSQ-93 for pgsql-hackers@lists.postgresql.org; Mon, 01 Jul 2024 16:52:04 +0000 Received: from mail-il1-x136.google.com ([2607:f8b0:4864:20::136]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sOKG2-004Wdc-Jj for pgsql-hackers@postgresql.org; Mon, 01 Jul 2024 16:52:03 +0000 Received: by mail-il1-x136.google.com with SMTP id e9e14a558f8ab-3737dc4a669so13248945ab.0 for ; Mon, 01 Jul 2024 09:52:02 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1719852720; x=1720457520; darn=postgresql.org; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:from:to:cc:subject:date:message-id:reply-to; bh=DHRtAAhLPJUTwe+R2xOcXQGHwvxXWnWiQ/WmDT+7bcs=; b=MvqGGNSgWO2L6tYm2T3TMcR6AxAsJwlDVdqmapTnHji4Sqr025WLMfiH0NRRxw6WTW XhzoY8558BMmdktu9DdDF0tuP6KRzSAGp/rQJSSVuIYncJyZrFkPlpHLLeR55gtr16z0 D4hHwdpmFH/qc8v/Vcr39rPC82AHJoh1nIskFJ3uVO9olbQJ07irkH356cc6HpuWjKRL bYV3AvXJ77+32bVIJH7Kn/2Sx2+GDvqFos/SIRW1QIwJAzamuR2y+muX1uigE9AX6PKC 2wdwwI4U3kGIrpL9NenrRHczg6QEy3LvPSf2nEVvArUlbUIJiOv+XqsGsOE5pGoUWdJ9 Evxw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1719852720; x=1720457520; h=in-reply-to:content-disposition:mime-version:references:message-id :subject:cc:to:from:date:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=DHRtAAhLPJUTwe+R2xOcXQGHwvxXWnWiQ/WmDT+7bcs=; b=nEbyTx61QDPlvMOSAcKfkhiKzQsgSjaUWoUuw71acxfFgj1Gbz+/j5zUBHTuzfO0gV 1DuwJ0G15u1tyz29Kjfi9iY41AiPg5u0XhBXOtOVYTGBBWBWury9duacXrrvX49yLmIA e0ZEep3m6DBuopjrzdhAn9v9r4pDE+cXO8v7uRf/Wf8KmhKncRwtKBoGQ2J2yo0v99Cj tNO+vXzz6WMpFBPPsTNGEwTNE76khq2L9+zIP3rSxcRRTu1qaAoh/rBQoy01ObpflsfL tHOm2WR3Y7s+xF5ANX1+tZAiAs+TugE5XuYgSWZetziEt61IIDpkU8bTXnFQNQMCMB/D lOvw== X-Forwarded-Encrypted: i=1; AJvYcCUJuoZxZlV1Pmfp1FeyVxlmby33MNZhEDXcJlQbpqQdnxccl8++5Fur3zH2vitNpApTRUe0AGV5LLyL+Fr9Kd4AASrQVe1waFYjmLnP X-Gm-Message-State: AOJu0YxL4lbgJqQMS8kN44r6qOMdWXA+w+SCbeb6oscqZMXbNVkhGTNd 0hF0ij0V7ZPmnmXc+dzyLaGYGflJVzebGL2bWdS2imOuPU/Krqc5pbUowsEN X-Google-Smtp-Source: AGHT+IEIKqsRpV6Wafef+YKpBkLKLBF5sxrTr9tDcd6Y6yqdSSjBoGXRxlSh2pd3RlhaR2q66kE4TQ== X-Received: by 2002:a92:c56c:0:b0:374:a286:7b3f with SMTP id e9e14a558f8ab-37cd17908d8mr85481005ab.14.1719852720446; Mon, 01 Jul 2024 09:52:00 -0700 (PDT) Received: from nathan (162-195-168-172.lightspeed.stlsmo.sbcglobal.net. [162.195.168.172]) by smtp.gmail.com with ESMTPSA id e9e14a558f8ab-37ad4370c90sm19546405ab.69.2024.07.01.09.51.59 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 01 Jul 2024 09:52:00 -0700 (PDT) Date: Mon, 1 Jul 2024 11:51:58 -0500 From: Nathan Bossart To: Michael Paquier Cc: Tom Lane , pgsql-hackers@postgresql.org Subject: Re: pg_sequence_last_value() for unlogged sequences on standbys Message-ID: References: <20240507171033.GA2524814@nathanxps13> <4179588.1715103856@sss.pgh.pa.us> <20240507184051.GA2600328@nathanxps13> <86044.1715108521@sss.pgh.pa.us> <20240507193942.GB2600328@nathanxps13> <20240510210055.GA428795@nathanxps13> <20240513210107.GA684121@nathanxps13> <20240517013335.GA1743971@nathanxps13> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20240517013335.GA1743971@nathanxps13> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, May 16, 2024 at 08:33:35PM -0500, Nathan Bossart wrote: > Here is a rebased version of 0002, which I intend to commit once v18 > development begins. Committed. -- nathan