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 1sM3SL-000O8U-8F for pgsql-general@arkaria.postgresql.org; Tue, 25 Jun 2024 10:31:21 +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 1sM3SJ-00EzPG-NO for pgsql-general@arkaria.postgresql.org; Tue, 25 Jun 2024 10:31:20 +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 1sM3Rt-00Eued-Gd for pgsql-general@lists.postgresql.org; Tue, 25 Jun 2024 10:30:53 +0000 Received: from mail-ed1-x52e.google.com ([2a00:1450:4864:20::52e]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1sM3Rm-0032Xb-4t for pgsql-general@lists.postgresql.org; Tue, 25 Jun 2024 10:30:52 +0000 Received: by mail-ed1-x52e.google.com with SMTP id 4fb4d7f45d1cf-57d07464aa9so5158635a12.2 for ; Tue, 25 Jun 2024 03:30:46 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1719311445; x=1719916245; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=UBKAraBIMU9xtGhODXB7vVF650BLcnc3txial24p68I=; b=aGwgfB1PF2lvE51KG6WK7HUizqjv2O/kznu+m3xQwHSSRaeGtAYCjyGLI+sS7vd5Ap 0T0mZ2IkGb6PFpoHOXqeDPfIt0XLyPMWPsRfUhGZEhZUdcZP5DgUwprDtix9pTNFcHJs QY9N//tEKgjaVvDZ2eIUcfoKI0aBKlwgJmN0cs+poi+wDLdwCpon+iVqjP7+xNO5p0pT PfaLFZN12XO27kGbImNBxBe/VTdMO3cCL3Wo0zpMmJ8bDgbG5vWsxsVN9dXPMSsS2bpP haL1yppHMfivmuHwc1ByJfITs+uuRzyFFLZQOkJi13aaWTMvuMIPH0qbTr2fTwC4GxoD RHsA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1719311445; x=1719916245; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=UBKAraBIMU9xtGhODXB7vVF650BLcnc3txial24p68I=; b=TpFDL2O6ErKpqQamY4QsQaQ5Wl5TlbkG50INibTVK68GASaSSWmQWSPMqIVsgHUssB U6qMUykg9P7U/winJ7wi80rb+ZDIjEf2APvsEglKw05j6fy7z34qTDJUxsPVyVvuEwM+ ZlSqQ0fIyDnpuDb+bTx+t8J2vZIY4fGDBUYmNZxvplMT+2bhNaPa6WgRcSmCNDsahBSu mMWppkX0nFoOvipC15sf1yM2+apWGFmOpV7MR4xEvYXx2ltFK1rTp6cg5PR8MkIzC0KY LM0thxOAwLcJXpMATS6Y5oCKJVyGFQfWv4Db1NBxBaf2K9IVV5nQolragwGb7kpbWRwY fcTg== X-Forwarded-Encrypted: i=1; AJvYcCXbMAxqxenQKVhaj/xNpAQp1ztf/D5+iLBxYxJkqQKwDWO830HPT1tTxFkj4EbJ5sDPEV0lDS8KqZKddt+BK5XrU/HrFXve07NWX5nkgfCS6Txv X-Gm-Message-State: AOJu0YyrN1E5A1Bd05T4vvS2RurYt4ca01XCLqC3WLLM1yhIbxEHCgHg ERld6RFOak0Y/h+IhnRdyGkzmYyMC1IlMCIAaDkTTKB7D7GKNB+oWSGTHgYvh9ZBrx2hevppmpT gQydGFLowaJwGjToIhCFcXS73dBM= X-Google-Smtp-Source: AGHT+IFKyr/305kBqm19BVG38MIxaONMb2GUa/prOoGGztl8QV88JVS1aFkRra+NptKDkbLzshT1YXQc3fJYZLeNkw0= X-Received: by 2002:a50:f604:0:b0:57c:aac9:cd8 with SMTP id 4fb4d7f45d1cf-57d4bd5648amr4999150a12.8.1719311444408; Tue, 25 Jun 2024 03:30:44 -0700 (PDT) MIME-Version: 1.0 References: <20240625.093750.1243120916203808312.t-ishii@sranhm.sra.co.jp.sranhm> In-Reply-To: <20240625.093750.1243120916203808312.t-ishii@sranhm.sra.co.jp.sranhm> From: Ayush Vatsa Date: Tue, 25 Jun 2024 16:00:33 +0530 Message-ID: Subject: Re: Issue with pgstattuple on Sequences in PostgreSQL To: Tatsuo Ishii Cc: david.g.johnston@gmail.com, pgsql-general@lists.postgresql.org Content-Type: multipart/alternative; boundary="000000000000e6fe78061bb463db" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000e6fe78061bb463db Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable > I agree it=E2=80=99s a documentation bug Thanks for confirmation, then maybe I can start a new thread in pgsql-hackers about this bug and I can myself create a patch for the same. > then the regression test should be fixed as well I will add regress test for sequences as well. We can remove *SEQUENCE* from https://github.com/postgres/postgres/blob/master/contrib/pgstattuple/pgstat= tuple.c#L255-L259 as well so that users can encounter *ERRCODE_FEATURE_NOT_SUPPORTED*. Thanks Ayush Vatsa SDE AWS --000000000000e6fe78061bb463db Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
>=C2=A0=C2=A0I agree it=E2=80=99s a do= cumentation bug
Thanks for confirmation, then maybe I can start a new th= read in pgsql-hackers about this bug and I can myself create a patch for th= e same.

> then the regression test should be fixed as= well
I will add regress test for sequences as well.

as well so that users can encou= nter=C2=A0ERRCODE_FEATURE_NOT_SUPPORTED.

Th= anks
Ayush Vatsa
SDE AWS
--000000000000e6fe78061bb463db--