Re: could not read block 0 in file "base/mydb/myfile": read only 0 of 8192 bytes

From: Dimitri Fontaine <dim(at)tapoueh(dot)org>
To: "Daniel Verite" <daniel(at)manitou-mail(dot)org>
Cc: mjoigny(at)neteven(dot)com, "pgsql-fr-generale" <pgsql-fr-generale(at)postgresql(dot)org>
Subject: Re: could not read block 0 in file "base/mydb/myfile": read only 0 of 8192 bytes
Date: 2016-05-31 21:26:33
Message-ID: m2vb1tudfa.fsf@tapoueh.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-fr-generale

"Daniel Verite" <daniel(at)manitou-mail(dot)org> writes:
> select * from pg_class where relfilenode=12119463;

Attention, utiliser la fonction pg_relation_filenode() ici :

select *
from pg_class
where pg_relation_filenode(oid::regclass) = 12119463;

Cela couvre les relation partagées (catalogues communs à toutes les
bases de données) et certains cas de réécritures de tables sur disque.

--
dim

--
Envoi via la liste pgsql-fr-generale (pgsql-fr-generale(at)postgresql(dot)org)

In response to

Responses

Browse pgsql-fr-generale by date

  From Date Subject
Next Message Michael JOIGNY 2016-06-01 09:24:35 Re: could not read block 0 in file "base/mydb/myfile": read only 0 of 8192 bytes
Previous Message Daniel Verite 2016-05-31 16:47:20 Re: could not read block 0 in file "base/mydb/myfile": read only 0 of 8192 bytes