X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 046B89F9D99 for ; Mon, 22 May 2006 14:56:59 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 82808-01 for ; Mon, 22 May 2006 14:56:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sydney.mailnetwork.co.uk (server88-208-192-113.live-servers.net [88.208.192.113]) by postgresql.org (Postfix) with ESMTP id 099049F9B01 for ; Mon, 22 May 2006 14:56:52 -0300 (ADT) Received: from andyshellam-gw.adsl.newnet.co.uk ([80.175.198.137]:1161 helo=[192.168.1.13]) by sydney.mailnetwork.co.uk with esmtpa (Exim 4.60) (envelope-from ) id 1FiEe9-0003lX-2C; Mon, 22 May 2006 18:56:49 +0100 Message-ID: <4471FB5D.6030707@andycc.net> Date: Mon, 22 May 2006 18:56:45 +0100 From: Andy Shellam Reply-To: andy@andycc.net Organization: AndyShellam.EU User-Agent: Thunderbird 1.5.0.2 (Windows/20060308) MIME-Version: 1.0 To: "Jim C. Nasby" CC: pgsql-admin@postgresql.org, xyxu@northwestern.edu Subject: Re: Error in Access References: <20060522164022.GT64371@pervasive.com> In-Reply-To: <20060522164022.GT64371@pervasive.com> Content-Type: multipart/alternative; boundary="------------000609000304070809050108" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200605/292 X-Sequence-Number: 21824 This is a multi-part message in MIME format. --------------000609000304070809050108 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Jim, This exact e-mail was also raised a few weeks ago! I advised Rocky to check the host server, and as it turned out, it's PG data partition was 100% full! I believe Rocky was covering for a system admin temporarily, hence the fact it wasn't picked up sooner. I don't know what happened since - whether he got it sorted. Regards Andy Jim C. Nasby wrote: > On Mon, May 15, 2006 at 10:09:25AM -0500, Xu, Xiaoyi (Rocky) FSM wrote: > >> Hi, >> >> My database users are getting following error: >> >> ODBC-call failed >> Error while executing query >> Error: ItsWriteBlock: failed to write block 1 of temporary file >> Perhaps out of disk space (#1) >> >> This happens in Access. Could anyone shed some light on this? Thank you. >> > > Does the command work if you run it from psql? > --------------000609000304070809050108 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Jim,

This exact e-mail was also raised a few weeks ago!  I advised Rocky to check the host server, and as it turned out, it's PG data partition was 100% full!  I believe Rocky was covering for a system admin temporarily, hence the fact it wasn't picked up sooner.  I don't know what happened since - whether he got it sorted.

Regards

Andy

Jim C. Nasby wrote:
On Mon, May 15, 2006 at 10:09:25AM -0500, Xu, Xiaoyi (Rocky) FSM wrote:
  
Hi,

My database users are getting following error:

ODBC-call failed
Error while executing query
Error: ItsWriteBlock: failed to write block 1 of temporary file
Perhaps out of disk space (#1)

This happens in Access. Could anyone shed some light on this? Thank you.
    

Does the command work if you run it from psql?
  

--------------000609000304070809050108--