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

From Olivier Macchioni
Subject Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes
Date
Msg-id 4EE3A338-8C14-4E1B-9F2B-479354765138@wingo.ch
Whole thread Raw
In response to 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>)
Responses Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes  (Bruce Momjian <bruce@momjian.us>)
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes
Next
From: erica.stine@mailinator.com
Date:
Subject: BUG #10330: pg_ctl does not correctly honor "DETACHED_PROCESS"