Re: problem trying to create a temp table

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