Postgres Pro
Downloads
Home   >   mailing lists

Re: spiexceptions.UndefinedFile: could not open file "base/16482/681830": No such file or directory - Mailing list pgsql-general

From Thomas Munro
Subject Re: spiexceptions.UndefinedFile: could not open file "base/16482/681830": No such file or directory
Date
Msg-id CA+hUKGLoNxWJcKc0JMOBJ=VyK_OTxK5jqQX9GKoEy0L9+-0=_Q@mail.gmail.com
Whole thread Raw
In response to spiexceptions.UndefinedFile: could not open file "base/16482/681830": No such file or directory  (Celia McInnis <celia.mcinnis@gmail.com>)
Responses Re: spiexceptions.UndefinedFile: could not open file "base/16482/681830": No such file or directory  (Celia McInnis <celia.mcinnis@gmail.com>)
List pgsql-general
Tree view 
On Thu, Sep 9, 2021 at 9:19 AM Celia McInnis <celia.mcinnis@gmail.com> wrote:
> Note that the file does exist:! (How do I know if it is looking under the correct directory? Other times I have done
similartemporary table creations with no problems!):
 

PostgreSQL internally uses relative paths.  It's probably not a very
good idea to use 'chdir' in a procedure.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: How does postgres behave if several indexes have (nearly) identical conditions?
Next
From: Celia McInnis
Date:
Subject: Re: spiexceptions.UndefinedFile: could not open file "base/16482/681830": No such file or directory