Re: BUG #19496: Assert("ItemPointerIsValid(pointer)") when using pageinspect - Mailing list pgsql-bugs

PG Bug reporting form <noreply@postgresql.org> writes:
> I found an assertion failure in pageinspect.

> SQL:
> CREATE EXTENSION IF NOT EXISTS pageinspect;
> WITH page AS (
>     SELECT set_byte(
>              set_byte(
>                set_byte(
>                  set_byte(
>                    set_byte(
>                      set_byte(
>                        set_byte(
>                          set_byte(decode(repeat('00', 8192), 'hex'),
>                                   12, 40),
>                          14, 248),
>                        15, 31),
>                      16, 248),
>                    17, 31),
>                  18, 4),
>                19, 32),
>              8190, 131) AS p
>   )
>   SELECT * FROM gin_leafpage_items((SELECT p FROM page));

Does that WITH actually construct a valid GIN page image?
I don't think we make any guarantee that pageinspect
won't crash on bad data.

            regards, tom lane