JPrasanna Venkatesan <[email protected]> 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: [email protected] p: 312.241.7800 -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
