Re: 8.4.0 data loss / HOT-related bug - Mailing list pgsql-bugs

From Greg Stark
Subject Re: 8.4.0 data loss / HOT-related bug
Date
Msg-id 407d949e0908221844xa9e7b97sbbb01c54a66d18b2@mail.gmail.com
Whole thread Raw
In response to Re: 8.4.0 data loss / HOT-related bug  (Radoslaw Zielinski <radek@pld-linux.org>)
Responses Re: 8.4.0 data loss / HOT-related bug  (Radoslaw Zielinski <radek@pld-linux.org>)
List pgsql-bugs
2009/8/22 Radoslaw Zielinski <radek@pld-linux.org>:
> =A0$ seq 11 | xargs -ti psql bug -c "select {}, (x).* from (select bt_pag=
e_items('promocje_pkey',{}) as x ) as y"
> =A0[...]
> =A0psql bug -c select 11, (x).* from (select bt_page_items('promocje_pkey=
',11) as x ) as y
> =A0ERROR: =A0block number out of range

Sorry, I forgot to adjust the index name in the example. We don't want
the primary key index of your table we want the index of the toast
table.

Try the same thing with bt_page_items('pg_toast.pg_toast_29644_index',...)


--=20
greg
http://mit.edu/~gsstark/resume.pdf

pgsql-bugs by date:

Previous
From: Greg Stark
Date:
Subject: Re: 8.4.0 data loss / HOT-related bug
Next
From: Craig Ringer
Date:
Subject: Re: BUG #4996: postgres.exe memory consumption keeps going up