Thread: create temporary table problem

create temporary table problem

From

JPrasanna Venkatesan

Date:

02 April 2013, 16:04:21

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

Re: create temporary table problem

From

Jerry Sievers

Date:

02 April 2013, 22:45:30

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