Re: Error in Access - Mailing list pgsql-admin

From Andy Shellam
Subject Re: Error in Access
Date
Msg-id 4471FB5D.6030707@andycc.net
Whole thread Raw
In response to Re: Error in Access  ("Jim C. Nasby" <jnasby@pervasive.com>)
Responses Re: Error in Access  ("Xu, Xiaoyi \(Rocky\) FSM" <xyxu@northwestern.edu>)
Re: Error in Access  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-admin
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? 

pgsql-admin by date:

Previous
From: "Jim C. Nasby"
Date:
Subject: Re: Updatable view and default sequence values
Next
From: "Xu, Xiaoyi \(Rocky\) FSM"
Date:
Subject: Re: Error in Access