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