Re: problem trying to create a temp table

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: problem trying to create a temp table
Дата
Msg-id 4F479523.1080606@archonet.com
обсуждение исходный текст
Ответ на Re: problem trying to create a temp table  (Andrew Gould <andrewlylegould@gmail.com>)
Список pgsql-general
On 24/02/12 13:37, Andrew Gould wrote:
> On Fri, Feb 24, 2012 at 7:32 AM, Richard Huxton<dev@archonet.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: problem trying to create a temp table
Следующее
От: Vick Khera
Дата:
Сообщение: Re: Configuring for very slow I/O