No space left on device.

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