Bruce Momjian wrote: > 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?
The only use of the dependencies is to disallow dropping the user that owns the table. But a connected user cannot be dropped. ... or so I thought :-( Actually you can delete a connected user, but things do not go well after you do: alvherre=> create table test (a int); ERREUR: le rôle 32792 a été supprimé simultanément So now my thinking is that we should disallow dropping a connected user. -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
