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: 407d949e0908221844xa9e7b97sbbb01c54a66d18b2@mail.gmail.com (view raw or flat)
Thread:
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
table.

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


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

In response to

Responses

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-2014 The PostgreSQL Global Development Group