Skip site navigation (1) Skip section navigation (2)

Re: 8.4.0 data loss / HOT-related bug

From: Greg Stark <gsstark(at)mit(dot)edu>
To: Radoslaw Zielinski <radek(at)pld-linux(dot)org>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: 8.4.0 data loss / HOT-related bug
Date: 2009-08-23 01:44:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
2009/8/22 Radoslaw Zielinski <radek(at)pld-linux(dot)org>:
>  $ seq 11 | xargs -ti psql bug -c "select {}, (x).* from (select bt_page_items('promocje_pkey',{}) as x ) as y"
>  [...]
>  psql bug -c select 11, (x).* from (select bt_page_items('promocje_pkey',11) as x ) as y
>  ERROR:  block 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

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


In response to


pgsql-bugs by date

Next:From: Craig RingerDate: 2009-08-23 02:37:49
Subject: Re: BUG #4996: postgres.exe memory consumption keeps going up
Previous:From: Greg StarkDate: 2009-08-23 01:40:19
Subject: Re: 8.4.0 data loss / HOT-related bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group