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

Reply via email to