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