Обсуждение: create temporary table problem
Dear All,
I am usnig PGSQL 9.0ERROR: could not create directory "pg_tblspc/16385/PG_9.0_201008051/20304": No such file or directory
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
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