Re: temp tables should not have pg_shdepend entries - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: temp tables should not have pg_shdepend entries
Date
Msg-id 200804081629.m38GTtC14470@momjian.us
Whole thread Raw
In response to temp tables should not have pg_shdepend entries  (Alvaro Herrera <alvherre@commandprompt.com>)
Responses Re: temp tables should not have pg_shdepend entries  (Alvaro Herrera <alvherre@commandprompt.com>)
List 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 by date:

Previous
From: Alvaro Herrera
Date:
Subject: temp tables should not have pg_shdepend entries
Next
From: Tom Lane
Date:
Subject: Re: Free Space Map data structure