Hi Nick,

> (firebird 2.1, centos, classic) I have this in the firebird.conf file

Which 2.1 version exactly?

> TempDirectories = /tmp;/var/tmp

Is this the real value, or are there spaces between the entries, size
restrictions in bytes?

> and yet, only /tmp was used and then the query quit with and out-of-space
> message.
>
> Can anyone see what it wrong with it, or is this a bug?

Bug? I vaguely recall something, but I can't remember exactly at the
moment. Have you searched the tracker?

Perhaps it is a permission issue so that firebird isn't allowed to write
into /var/tmp?

--
With regards,
Thomas Steinmaurer (^TS^)
Firebird Technology Evangelist

http://www.upscene.com/
http://www.firebirdsql.org/en/firebird-foundation/