No space left on device. - Mailing list pgsql-novice

From Chad Thompson
Subject No space left on device.
Date
Msg-id 032501c2454c$f1285ae0$32021aac@chad
Whole thread Raw
Responses Re: No space left on device.
List pgsql-novice
I have recieved a very weird error when running the following query.
 
select
l.id, l.full_phone into "8_15_2002_NeverquitPushOneMessaging"
from
list_tz l, call_results cr
where
client_id = 8
and
((cr.result = 'Busy') or (cr.result = 'Busy-Reorder') or (cr.result = 'Busy-Timeout') or (cr.result = 'No Signal') or (cr.result = 'No Circuit Signal') or (cr.result = 'No Answer') or (cr.result = 'No Solicitation'))
and
cr.calldate between '6/4/2002'  and '8/14/2002';
 
call_results is a table with just over 1 million lines, list_tz is a temp table created in another function w/ anywhere from 10 to 50 K lines.
 
here is the error
 
cannot extend 8_15_2002_NeverquitPushOneMessa: no space left on device
        check free disk space.
 
I have checked the archives and it gave me an indication that my sql might be wrong, but i cant figure out what.  I have also tried the query using IN (eg. and cr.result in('busy',busy-reorder....))
 
Here is my system info
 
Im running redhat 7.2
df says
Filesystem           1k-blocks      Used Available Use% Mounted on
/dev/hda1             19188368   2960536  15253092  17% /
none                    385340         0    385340   0% /dev/shm
select version();
                          version
-----------------------------------------------------------
 PostgreSQL 7.2 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
 
I have installed postgresql with just the default settings. 
 
Any help would be appreciated
TIA
Chad

pgsql-novice by date:

Previous
From: "Chad Thompson"
Date:
Subject: Re: BLOBs
Next
From: douggorley@shaw.ca
Date:
Subject: Re: Is my database done for?