Re: "could not open relation 1663/16384/16584: No suchfile or directory" in a specific combination of transactions withtemp tables

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "John Smith" <sodgodofall(at)gmail(dot)com>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: "could not open relation 1663/16384/16584: No suchfile or directory" in a specific combination of transactions withtemp tables
Date: 2008-03-03 12:39:41
Message-ID: 47CBF18D.6010000@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Alvaro Herrera wrote:
> Heikki Linnakangas escribió:
>
>> In the future, it would be nice to relax the restriction on using temp
>> rels, though. A flag doesn't lend itself to that easily, but I'm sure
>> we'll figure out something if we ever get around to implement that.
>
> I can't recall the rationale for this limitation. Do we need anything
> beyond flushing the table's buffers to disk? That sounds an easy thing
> to implement.

See http://archives.postgresql.org/pgsql-hackers/2005-05/msg01223.php

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2008-03-03 14:23:50 Patch application emails
Previous Message Alvaro Herrera 2008-03-03 12:13:56 Re: "could not open relation 1663/16384/16584: No such file or directory" in a specific combination of transactions with temp tables