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)
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 |
PostgreSQL : Re : | 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 |