From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: bchen90@163.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18112: pgstattuple of sequence failed
Date: Wed, 20 Sep 2023 10:26:07 +0200
Message-ID: <202309200826.z3ckjb4g7auj@alvherre.pgsql> (raw)
In-Reply-To: <18112-724de41f491c9878@postgresql.org>
On 2023-Sep-15, PG Bug reporting form wrote:
> I found pgstattuple of sequence will be failed but not PG11.x, for the code
> of pgstattuple it looks like still support of sequence, but the
> "rel->rd_rel->relam now is 0, not HEAP_TABLE_AM_OID", so the error report
>
> postgres=# select pgstattuple('test');
> ERROR: SQLSTATE 0A000: only heap AM is supported
OK, but so what? I mean, what useful information are you extracting
using pgstattuple from a sequence? What decisions can you make based on
these results?
--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
"We're here to devour each other alive" (Hobbes)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: alvherre@alvh.no-ip.org, bchen90@163.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #18112: pgstattuple of sequence failed
In-Reply-To: <202309200826.z3ckjb4g7auj@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox