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

Dimitri Fontaine <[email protected]>
Newsgroups gmane.comp.db.postgresql.french
Message-ID <[email protected]>
"Daniel Verite" <[email protected]> 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 ([email protected])
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.