Hi!

I'm doing a select (from an OACS page or from psql) and I get:
ERROR:  Failed to create temporary file pgsql_tmp/pgsql_tmp27212.775

The same select work ok a different database (which is on a different
machine)

the select is :
select a.attribute_id, a.pretty_name,
           a.ancestor_type, t.pretty_name as ancestor_pretty_name
      from acs_object_type_attributes a,
           (select t2.object_type, t2.pretty_name,
     tree_level(t2.tree_sortkey) - tree_level(t1.tree_sortkey) + 1 as
type_level
              from acs_object_types t1, acs_object_types t2
      where t1.object_type = 'group'
        and t2.tree_sortkey between t1.tree_sortkey and
tree_right(t1.tree_sortkey)) t
     where a.object_type = 'group'
       and t.object_type = a.ancestor_type
    order by type_level


Thu, 23 Oct 2003 11:00:52 +0200
Yuval Lieberman <yuvallb@netvision.net.il>
Failed to create temporary file
Sounds like your drives are full.

On Thu, 23 Oct 2003, Yuval Lieberman wrote:

> Hi!
> 
> I'm doing a select (from an OACS page or from psql) and I get:
> ERROR:  Failed to create temporary file pgsql_tmp/pgsql_tmp27212.775
> 
> The same select work ok a different database (which is on a different
> machine)
> 
> the select is :
> select a.attribute_id, a.pretty_name,
>            a.ancestor_type, t.pretty_name as ancestor_pretty_name
>       from acs_object_type_attributes a,
>            (select t2.object_type, t2.pretty_name,
>      tree_level(t2.tree_sortkey) - tree_level(t1.tree_sortkey) + 1 as
> type_level
>               from acs_object_types t1, acs_object_types t2
>       where t1.object_type = 'group'
>         and t2.tree_sortkey between t1.tree_sortkey and
> tree_right(t1.tree_sortkey)) t
>      where a.object_type = 'group'
>        and t.object_type = a.ancestor_type
>     order by type_level
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
> 
>                http://www.postgresql.org/docs/faqs/FAQ.html
> 
> 


Thu, 23 Oct 2003 14:25:54 -0600 (MDT)
"scott.marlowe" <scott.marlowe@ihs.com>
Re: Failed to create temporary file