Re: temp tables should not have pg_shdepend entries

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: temp tables should not have pg_shdepend entries
Дата
Msg-id 200804081629.m38GTtC14470@momjian.us
обсуждение исходный текст
Ответ на temp tables should not have pg_shdepend entries  (Alvaro Herrera <alvherre@commandprompt.com>)
Ответы Re: temp tables should not have pg_shdepend entries  (Alvaro Herrera <alvherre@commandprompt.com>)
Список pgsql-hackers
Alvaro Herrera wrote:
> Among the consequences of creating a temp table is the fact that we
> create pg_shdepend entries for the owner.  This is largely unnecessary
> -- we only need it when the table owner is not the authenticated user.
> I hereby propose we don't create those entries, since obviously the
> tables would go away as soon as the connection goes away anyway, and the
> user cannot go away until the connection does.

But what if some application is using those dependencies while the
session is running?  What is the advantage of not having the entries?

--  Bruce Momjian  <bruce@momjian.us>        http://momjian.us EnterpriseDB
http://enterprisedb.com
 + If your life is a hard drive, Christ can be your backup. +


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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: temp tables should not have pg_shdepend entries
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Free Space Map data structure