Re: Help on copy function

From: Doug McNaught <doug(at)mcnaught(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: frederic(dot)germaneau(at)bull(dot)net, pgsql-general(at)postgresql(dot)org
Subject: Re: Help on copy function
Date: 2004-10-06 22:38:35
Message-ID: 87wty3jwus.fsf@asmodeus.mcnaught.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Doug McNaught <doug(at)mcnaught(dot)org> writes:

>> It's also possible that PG is trying to create a new table file and
>> he's out of inodes...
>
> Good thought, although I think that this particular error message would
> only come out from a seek/write failure and not from an open failure.
> In any case it's some sort of externally imposed resource limit ...

Yeah. My first reaction to "inexplicable ENOSPC" is always "are you
out of inodes?" just because I've been bitten by it several times and
felt like an idiot afterwards. ;)

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
--T. J. Jackson, 1863

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Frankel 2004-10-06 23:04:31 Re: postgres.h location?
Previous Message Bruce Momjian 2004-10-06 22:26:05 Re: postgres.h location?