sorry my mistake, it should be temp_tablespaces. I use PG 8.3.0-1> Date: Thu,
15 Jan 2009 09:00:09 -0800> From: [email protected]> To:
[email protected]> Subject: Re: [postgis-users] postgre
tmp_tablespace> > What version of PostgreSQL are you using? I don't see that
variable in 8.3.> postgis=# show tmp_tablespace;> ERROR: unrecognized
configuration parameter "tmp_tablespace"> > I would imagine it's the directory
location for temporary files. According to the 8.3 docs:> "Temporary files (for
operations such as sorting more data than can fit in memory) are created within
> PGDATA/base/pgsql_tmp, or within a pgsql_tmp subdirectory of a tablespace
directory if a tablespace other than > pg_default is specified for them. The
name of a temporary file has the form pgsql_tmpPPP.NNN, where PPP is the PID of
> the owning backend and NNN distinguishes different files of that backend."> >
Cheers,> Kevin> > > P Adji wrote:> > Dear all,> > sorry if it is not postgis
related.> > > > whats the variable tmp_tablespace in postgre is for ?> > > >
thanks guys> > > >
------------------------------------------------------------------------> >
Share your beautiful moments with Photo Gallery. Windows Live Photo > > Gallery
<http://get.live.com/photogallery/overview>> > > > > >
------------------------------------------------------------------------> > > >
_______________________________________________> > postgis-users mailing list>
> [email protected]> >
http://postgis.refractions.net/mailman/listinfo/postgis-users>
_______________________________________________> postgis-users mailing list>
[email protected]>
http://postgis.refractions.net/mailman/listinfo/postgis-users
_________________________________________________________________
See all the ways you can stay connected to friends and family
http://www.microsoft.com/windows/windowslive/default.aspx
_______________________________________________
postgis-users mailing list
[email protected]
http://postgis.refractions.net/mailman/listinfo/postgis-users
