Re: problem trying to create a temp table

From: Richard Huxton <dev(at)archonet(dot)com>
To: Andrew Gould <andrewlylegould(at)gmail(dot)com>
Cc: mgould(at)isstrucksoftware(dot)net, "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:48:19
Message-ID: 4F479523.1080606@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 24/02/12 13:37, Andrew Gould wrote:
> On Fri, Feb 24, 2012 at 7:32 AM, Richard Huxton<dev(at)archonet(dot)com> wrote:
>>
>> Temp tables get their own schema, and each session (connection) gets
>> its own temp schema. So - don't qualify them by schema.
>
> Is that to avoid naming conflicts between simultaneous users?

Yes. I believe it also invisibly adds it to your search_path too, the
same as it does with the pg_catalog schema.

--
Richard Huxton
Archonet Ltd

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Vick Khera 2012-02-24 14:36:38 Re: Configuring for very slow I/O
Previous Message Richard Huxton 2012-02-24 13:46:52 Re: problem trying to create a temp table