Strange error when executing PgSQL query

[pablogosse]

Hi all. I've had a job centre application up and running for a few weeks now with very little trouble.

However today one of the pages is giving a really strange error whenever the following query is executed:

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

[/b]

I get the following error:

Failed to create temporary file pgsql_tmp/pgsql_tmp29459.0

[/b]

I get this error both from the php script and when I execute the query from the command line.

Does anyone know what could be causing it? I'm the only person who does anything with the database so nothing that I know of has changed. Any help is greatly appreciated.

Thanks in advance,
Pablo