Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes

Поиск
Список
Период
Сортировка
От Olivier Macchioni
Тема Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes
Дата
Msg-id 4EE3A338-8C14-4E1B-9F2B-479354765138@wingo.ch
обсуждение исходный текст
Ответ на Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes
Список pgsql-bugs
> [...]
> "hash_idx"?  Is this a hash index?  Those aren't supported for =
replication
> purposes (no WAL code :-().
>=20
>             regards, tom lane

Bingo:

xx=3D# \d ir_translation_src_hash_idx
Index "public.ir_translation_src_hash_idx"
 Column |  Type   | Definition
--------+---------+------------
 src    | integer | src
hash, for table "public.ir_translation"


(for the record, this is created by the stock version of OpenERP v6)

And it's the only hash index out of 1741 other indexes on my system...=20=


I guess my best bet is to replace it by another kind of indexes... and =
maybe one day PostgreSQL will be clever enough to issue a warning / =
error in such a case for the people like me who don't read *all the doc* =
:P

Thanks a lot and sorry for the noise :)

Olivier=

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes
Следующее
От: erica.stine@mailinator.com
Дата:
Сообщение: BUG #10330: pg_ctl does not correctly honor "DETACHED_PROCESS"