Postgres Pro
Downloads
Home   >   mailing lists

Re: Plsql Function with error: No space left on device. - Mailing list pgsql-sql

From Tom Lane
Subject Re: Plsql Function with error: No space left on device.
Date
Msg-id 8081.993650872@sss.pgh.pa.us
Whole thread Raw
In response to Re: Plsql Function with error: No space left on device.  ("David M. Richter" <D.Richter@DKFZ-heidelberg.de>)
List pgsql-sql
Tree view 
"David M. Richter" <D.Richter@DKFZ-heidelberg.de> writes:
> FATAL 2:  ZeroFill(/usr/local/pgsql/data/pg_xlog/xlogtemp.30164) failed:
> No such file or directory

You ran out of disk space.

Yes, the error message is misleading.  That's fixed in current sources.
See also 
http://www.ca.postgresql.org/mhonarc/pgsql-patches/2001-06/msg00061.html
        regards, tom lane

pgsql-sql by date:

Previous
From: "David M. Richter"
Date:
Subject: Re: Plsql Function with error: No space left on device.
Next
From: Jan Wieck
Date:
Subject: Re: Storing image contents in TEXT fields