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