Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f5RE8Ea00613 for ; Wed, 27 Jun 2001 10:08:15 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id f5RE7qF08084; Wed, 27 Jun 2001 10:07:52 -0400 (EDT) To: "David M. Richter" cc: Richard Huxton , pgsql-sql@postgresql.org Subject: Re: Plsql Function with error: No space left on device. In-reply-to: <3B39DA5C.FBC63A7B@DKFZ-heidelberg.de> References: <3B36FB6E.1039F0D4@DKFZ-heidelberg.de> <005601c0fd60$db576740$1001a8c0@archonet.com> <3B388D05.C3919F0F@DKFZ-heidelberg.de> <3122.993567296@sss.pgh.pa.us> <3B39DA5C.FBC63A7B@DKFZ-heidelberg.de> Comments: In-reply-to "David M. Richter" message dated "Wed, 27 Jun 2001 15:06:36 +0200" Date: Wed, 27 Jun 2001 10:07:52 -0400 Message-ID: <8081.993650872@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200106/432 X-Sequence-Number: 3729 "David M. Richter" 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