Re: 8.4.0 data loss / HOT-related bug

Поиск
Список
Период
Сортировка
От Greg Stark
Тема Re: 8.4.0 data loss / HOT-related bug
Дата
Msg-id 407d949e0908221844xa9e7b97sbbb01c54a66d18b2@mail.gmail.com
обсуждение исходный текст
Ответ на Re: 8.4.0 data loss / HOT-related bug  (Radoslaw Zielinski <radek@pld-linux.org>)
Ответы Re: 8.4.0 data loss / HOT-related bug  (Radoslaw Zielinski <radek@pld-linux.org>)
Список 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 по дате отправления:

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: 8.4.0 data loss / HOT-related bug
Следующее
От: Craig Ringer
Дата:
Сообщение: Re: BUG #4996: postgres.exe memory consumption keeps going up