create temporary table problem

[JPrasanna Venkatesan <prasanna1981@xxxxxxxxx>]

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

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