Horton

Re: Issue with pgstattuple on Sequences in PostgreSQL

Ayush Vatsa <ayushvatsa1810@gmail.com>

View thread View on postgr.es
From: Ayush Vatsa <ayushvatsa1810@gmail.com>
To: Tatsuo Ishii <ishii@sraoss.co.jp>
Cc: david.g.johnston@gmail.com, pgsql-general@lists.postgresql.org
Date: 2024-06-25T10:30:33Z
Lists: pgsql-general 
>  I agree it’s 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/pgstattuple.c#L255-L259

as well so that users can encounter *ERRCODE_FEATURE_NOT_SUPPORTED*.

Thanks
Ayush Vatsa
SDE AWS

Commits

  1. Only allow heap in a number of contrib modules.