Postgres Pro
Downloads
Home   >   mailing lists

Re: problem trying to create a temp table - Mailing list pgsql-general

From Richard Huxton
Subject Re: problem trying to create a temp table
Date
Msg-id 4F479154.7070409@archonet.com
Whole thread Raw
In response to problem trying to create a temp table  (<mgould@isstrucksoftware.net>)
Responses Re: problem trying to create a temp table  (Andrew Gould <andrewlylegould@gmail.com>)
List pgsql-general
Tree view 
On 24/02/12 13:26, mgould@isstrucksoftware.net wrote:

> ALL,
> Using 9.1.2 on Windows 7 X64 for development.
> I'm trying to create a temporary table used to store session variables
>  CREATE TEMP TABLE iss.sessionsettings

> When I try and run this I get the following error message.
> ERROR: cannot create temporary relation in non-temporary schema
Temp tables get their own schema, and each session (connection) gets
its own temp schema. So - don't qualify them by schema.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From:
Date:
Subject: problem trying to create a temp table
Next
From:
Date:
Subject: Re: problem trying to create a temp table