JPrasanna Venkatesan <prasanna1981@xxxxxxxxx> 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@xxxxxxxxxxx p: 312.241.7800 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
