Re: Tablespace for temporary objects and sort files

On 10/25/06, Jaime Casanova <systemguards(at)gmail(dot)com> wrote:
> On 10/24/06, Albert Cervera Areny <albertca(at)hotpop(dot)com> wrote:
> > I'm trying to introduce myself into postgresql development and I'm working on
> > the "tablespace for temporary objects and sort files" TODO item.
>
>
> Now, PG_TEMP_FILES_DIR seems to add just pgsql_temp to the filename. i
> think you the function you have to modify here is
> make_database_relative() that adds base/#database_oid# at the
> beginning of the path of the file.
>

some tests shows that your patch is doing the wrong thing for temp
files, actually the server is crashing

--
regards,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
Richard Cook