Обсуждение: Re: == PostgreSQL Weekly News - July 29 2007 ==

Поиск
Список
Период
Сортировка

Re: == PostgreSQL Weekly News - July 29 2007 ==

От
Joseph S
Дата:
David Fetter wrote:
> == PostgreSQL Weekly News - July 29 2007 ==

> - Arrange to put TOAST tables belonging to temporary tables into
>   special schemas named pg_toast_temp_nnn, alongside the pg_temp_nnn

Does this apply to indexes on temp tables as well?  Or is this not even
an issue with indexes?

Re: == PostgreSQL Weekly News - July 29 2007 ==

От
Tom Lane
Дата:
Joseph S <jks@selectacast.net> writes:
> David Fetter wrote:
>> - Arrange to put TOAST tables belonging to temporary tables into
>> special schemas named pg_toast_temp_nnn, alongside the pg_temp_nnn

> Does this apply to indexes on temp tables as well?  Or is this not even
> an issue with indexes?

Indexes always live in the same schema as their parent table.

            regards, tom lane