Re: problem trying to create a temp table

From: Richard Huxton <dev(at)archonet(dot)com>
To: mgould(at)isstrucksoftware(dot)net
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: problem trying to create a temp table
Date: 2012-02-24 13:32:04
Message-ID: 4F479154.7070409@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 24/02/12 13:26, mgould(at)isstrucksoftware(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mgould 2012-02-24 13:36:30 Re: problem trying to create a temp table
Previous Message mgould 2012-02-24 13:26:21 problem trying to create a temp table