| From: | Olivier Macchioni <olivier(dot)macchioni(at)wingo(dot)ch> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes |
| Date: | 2014-05-15 15:20:35 |
| Message-ID: | 4EE3A338-8C14-4E1B-9F2B-479354765138@wingo.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | Postg사설 토토SQL : Postg사설 토토SQL 메일 링리스트 : 2014-05-15 이후 PGSQL-BUGS. |
> [...]
> "hash_idx"? Is this a hash index? Those aren't supported for replication
> purposes (no WAL code :-().
>
> regards, tom lane
Bingo:
xx=# \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...
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | erica.stine | 2014-05-15 15:46:20 | BUG #10330: pg_ctl does not correctly honor "DETACHED_PROCESS" |
| Previous Message | Tom Lane | 2014-05-15 15:09:47 | Re: BUG #10329: Could not read block 0 in file "base/56100265/57047884": read only 0 of 8192 bytes |