2009/8/22 Radoslaw Zielinski <ra...@pld-linux.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 -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs