Re: ERROR: _mdfd_getrelnfd: cannot open relation pg_temp_15300_53: No such file or directory
От | Andrew Bartley |
---|---|
Тема | Re: ERROR: _mdfd_getrelnfd: cannot open relation pg_temp_15300_53: No such file or directory |
Дата | |
Msg-id | 061801c2795c$adfd83a0$3200a8c0@abartleypc обсуждение исходный текст |
Ответ на | Looking for foreign key guinea pigs (Stephan Szabo <sszabo@megazone23.bigpanda.com>) |
Список | pgsql-general |
Thanks again. ----- Original Message ----- From: "Tom Lane" <tgl@sss.pgh.pa.us> To: "Andrew Bartley" <abartley@evolvosystems.com> Cc: <pgsql-general@postgresql.org> Sent: Tuesday, October 22, 2002 9:30 AM Subject: Re: [GENERAL] ERROR: _mdfd_getrelnfd: cannot open relation pg_temp_15300_53: No such file or directory > "Andrew Bartley" <abartley@evolvosystems.com> writes: > > I have tried to but together a shell script to touch these files. But it > > seems that the table in question has a second pg_toast oid associated with > > it. > > That's interesting ... if both those physical files went away while the > pg_class rows remained, it suggests some systematic problem rather than > just a random glitch. I doubt we'll be able to learn anything about the > cause if we're not allowed into the database machine though :-( > > Anyway, the pg_class.reltoastrelid field for the temp table gives you > the OID of the pg_class row for its TOAST table, from which you can get > the relfilenode value to touch for the TOAST table. > > Very likely, the TOAST table's index has got the same disease: to find > it, get the reltoastidxid field from the TOAST table's pg_class row, and > again go to that OID in pg_class to see its relfilenode value. > > (Actually, in 7.2 you'll almost certainly find that relfilenode of each > of these rows matches its OID, but to be perfectly safe you should look > up and use the relfilenode.) > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org > >
В списке pgsql-general по дате отправления: