On Fri, Feb 24, 2012 at 7:32 AM, Richard Huxton <dev@archonet.com> wrote:
> 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
>
Is that to avoid naming conflicts between simultaneous users?
Andrew