Re: strange disappearence of postgres file

Поиск
Список
Период
Сортировка
От Qingqing Zhou
Тема Re: strange disappearence of postgres file
Дата
Msg-id dm0f8q$dq8$1@news.hub.org
обсуждение исходный текст
Ответ на strange disappearence of postgres file  (Harald Armin Massa <haraldarminmassa@gmail.com>)
Ответы Re: strange disappearence of postgres file  (Harald Armin Massa <haraldarminmassa@gmail.com>)
Список pgsql-bugs
"Harald Armin Massa" <haraldarminmassa@gmail.com> wrote
>
> 2005-11-21 09:45:50 ERROR: could not open relation 1663/17253/43471: No
> such
> file or directory
>
> My checking showed that... within directory data/base/17253 there is
> indeed
> no file named 43471; but ones named 43470,43472,43473 .....
>

This may be not a direct step to solve the problem, but let's get some
feelings first:

Is 43471 a temp table? To find out this: "select relname, nspname from
pg_class, pg_namespace where pg_namespace.oid=pg_class.relnamespace and
relfilenode = 43471;"

Regards,
Qingqing

В списке pgsql-bugs по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP
Следующее
От: "Qingqing Zhou"
Дата:
Сообщение: Re: BUG #2063: Unsupported frontend protocol