Problem joining tables

[pablogosse]

I've got the following query which joins two tables:

select j.*,e.name from jb_jobs j, jb_employers e where j.emp_id = e.emp_id;

which produces the following error:

ERROR: Failed to create temporary file pgsql_tmp/pgsql_tmp29669.0

I can join other tables in the database no problem, and nothing has changed recently, but this error just started showing up in the past 24 hours.

Any ideas?

P.

[ultraslacker]

I've never seen this error on 7.2 - what version are you running?

Unless someone pops in with the answer, I'd post this to postgres mailing list.

[pablogosse]

Yeah, it's a weird one. Here's the full query (naming the columns instead of using *):

select          j.job_id,
                j.emp_id,  

                j.job_title,  

                j.education_levels,  

                j.addtl_acad_req,  

                j.hours,  

                j.job_type,  

                j.wage,  

                j.location,  

                j.start_date,  

                j.vacancies,  

                j.app_deadline,  

                --j.job_desc,
                --j.inclusions,
                j.other_inclusions,  

                --j.delivery_method,
                --j.contact_person,
                j.status,  

                j.submission_date,  

                --j.timestamp,
                j.coop,  

                e.name
from            jb_jobs j,jb_employers e
where           j.emp_id = e.emp_id;

If I uncomment either of the columns which I've commented out the query returns the error I mentioned.

I had little to no response from posting it to a few postgresql forums, so I figured I'd try here.

[ultraslacker]

I would recommend the devshed forum for postgresql and the postgresql mailing lists.

How about space in $PGDATA (or wherever pgsql_tmp is)?