From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Yuval Lieberman <yuvallb(at)netvision(dot)net(dot)il> |
Cc: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Failed to create temporary file |
Date: | 2003-10-23 20:25:54 |
Message-ID: | Pine.LNX.4.33.0310231425470.21899-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Hannu Krosing | 2003-10-23 22:46:13 | Re: Dreaming About Redesigning SQL |
Previous Message | Andrew Dunstan | 2003-10-23 17:58:09 | Re: [HACKERS] pg_ctl reports succes when start fails |