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