Postgres Pro
Downloads
Home   >   mailing lists

create temporary table problem - Mailing list pgsql-general

From JPrasanna Venkatesan
Subject create temporary table problem
Date
Msg-id CAEyZNqi0H9159xq+ghf5bbC2xUdr5JBeGZVUrUj8CtEyHTYv+g@mail.gmail.com
Whole thread Raw
Responses Re: create temporary table problem
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Ray Stell
Date:
Subject: sql text
Next
From: Joe Van Dyk
Date:
Subject: Re: Trigger of Transaction