create temporary table problem

From: JPrasanna Venkatesan <prasanna1981(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org, JPrasanna Venkatesan <prasanna1981(at)gmail(dot)com>
Subject: create temporary table problem
Date: 2013-04-02 13:04:06
Message-ID: CAEyZNqi0H9159xq+ghf5bbC2xUdr5JBeGZVUrUj8CtEyHTYv+g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Van Dyk 2013-04-02 15:29:30 Re: [GENERAL] Trigger of Transaction
Previous Message Ray Stell 2013-04-02 12:27:50 sql text