Skip site navigation (1) Skip section navigation (2)

Re: strange disappearence of postgres file

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: strange disappearence of postgres file
Date: 2005-11-23 01:06:00
Message-ID: dm0f8q$dq8$1@news.hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
"Harald Armin Massa" <haraldarminmassa(at)gmail(dot)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 



In response to

Responses

pgsql-bugs by date

Next:From: Qingqing ZhouDate: 2005-11-23 01:16:08
Subject: Re: BUG #2063: Unsupported frontend protocol
Previous:From: David FetterDate: 2005-11-22 23:34:53
Subject: Re: BUG #2051: CREATE TEMP TABLE AS SELECT doesn't play nice with ON COMMIT DROP

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group