From: | "Chad Thompson" <chad(at)weblinkservices(dot)com> |
---|---|
To: | "pgsql-novice" <pgsql-novice(at)postgresql(dot)org> |
Subject: | No space left on device. |
Date: | 2002-08-16 17:47:06 |
Message-ID: | 032501c2454c$f1285ae0$32021aac@chad |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | douggorley | 2002-08-16 18:07:51 | Re: Is my database done for? |
Previous Message | Chad Thompson | 2002-08-16 16:52:53 | Re: BLOBs |