Re: create temporary table problem

JPrasanna Venkatesan <prasanna1981@gmail.com> writes:

> Dear All,
>
> I am usnig PGSQL 9.0
>
> When I tried to create a temporary table it is throwing the following error
>
> ERROR:? could not create directory "pg_tblspc/16385/PG_9.0_201008051/20304": No such file or directory

You forgot to migrate your tablespaces when you did the upgrade and
temp_tablespaces is set to an invalid one.

> Whole snippet is like this
>
> ctfdb=> create temporary table assoc ( origin varchar(32), target varchar(255), type varchar(128), descr text,
> generation int, relid varchar(32) );
> ERROR:? could not create directory "pg_tblspc/16385/PG_9.0_201008051/20304": No such file or directory
>
> The same query work in PGSQL 8.0
>
> Please guide me.
>
> Regards,
> J Prasanna Venkatesan
>

--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800