Horton

Re: pg_walinspect last query typo

Daniel Gustafsson <daniel@yesql.se>

View thread View on postgr.es
From: Daniel Gustafsson <daniel@yesql.se>
To: jian he <jian.universality@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, bharath.rupireddyforpostgres@gmail.com
Date: 2023-05-25T09:16:38Z
Lists: pgsql-hackers 
> On 25 May 2023, at 11:13, jian he <jian.universality@gmail.com> wrote:
> 
> hi.
> https://www.postgresql.org/docs/current/pgwalinspect.html
> 
> last query should be:
> SELECT * FROM pg_get_wal_stats('0/1E847D00', '0/1E84F500')
> WHERE   count > 0 AND
>         "resource_manager/record_type" = 'Transaction'
> LIMIT 1;

Nice catch, the LIMIT 1 has indeed landed in the wrong place. Will fix.

--
Daniel Gustafsson

Commits

  1. doc: Fix example query for pg_walinspect