Postgres Pro
Downloads
Home   >   mailing lists

Re: "could not open relation 1663/16384/16584: No such file or directory" in a specific combination of transactions with temp tables - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: "could not open relation 1663/16384/16584: No such file or directory" in a specific combination of transactions with temp tables
Date
Msg-id 20080303121356.GA5271@alvh.no-ip.org
Whole thread Raw
In response to Re: "could not open relation 1663/16384/16584: No such file or directory" in a specific combination of transactions with temp tables  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Responses Re: "could not open relation 1663/16384/16584: No suchfile or directory" in a specific combination of transactions withtemp tables  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
List pgsql-hackers
Tree view 
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.

-- 
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-hackers by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: Read-ahead and parallelism in redo recovery
Next
From: "Heikki Linnakangas"
Date:
Subject: Re: "could not open relation 1663/16384/16584: No suchfile or directory" in a specific combination of transactions withtemp tables