BUG #18112: pgstattuple of sequence failed

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: bchen90(at)163(dot)com
Subject: BUG #18112: pgstattuple of sequence failed
Date: 2023-09-15 10:47:00
Message-ID: 18112-724de41f491c9878@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18112
Logged by: Bo Chen
Email address: bchen90(at)163(dot)com
PostgreSQL version: 15.2
Operating system: euleros
Description:

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=# drop Sequence test;
DROP SEQUENCE
postgres=# create Sequence test;
CREATE SEQUENCE
postgres=# select pgstattuple('test');
ERROR: SQLSTATE 0A000: only heap AM is supported
LOCATION: pgstat_heap, pgstattuple.c:322
postgres=#

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Devrim Gündüz 2023-09-15 11:28:13 Re: BUG #17943: Undefined symbol LLVMBuildGEP in llvmjit.so during pg_restore
Previous Message David Rowley 2023-09-15 10:19:41 Re: BUG #18108: server process was terminated by signal 11: Segmentation fault