[HACKERS] temp tables should not have pg_shdepend entries

2008-04-08 Thread Alvaro Herrera
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

Re: [HACKERS] temp tables should not have pg_shdepend entries

2008-04-08 Thread Bruce Momjian
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

Re: [HACKERS] temp tables should not have pg_shdepend entries

2008-04-08 Thread Alvaro Herrera
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

Re: [HACKERS] temp tables should not have pg_shdepend entries

2008-04-08 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: So now my thinking is that we should disallow dropping a connected user. I agree with that, but I think your idea of not making the pg_shdepend entries is a pointless and possibly dangerous micro-optimization. How much actual speedup would it provide,

Re: [HACKERS] temp tables should not have pg_shdepend entries

2008-04-08 Thread Alvaro Herrera
Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: So now my thinking is that we should disallow dropping a connected user. I agree with that, but I think your idea of not making the pg_shdepend entries is a pointless and possibly dangerous micro-optimization. How much actual speedup

Re: [HACKERS] temp tables should not have pg_shdepend entries

2008-04-08 Thread Tom Lane
Alvaro Herrera [EMAIL PROTECTED] writes: Tom Lane wrote: I agree with that, but I think your idea of not making the pg_shdepend entries is a pointless and possibly dangerous micro-optimization. How much actual speedup would it provide, anyway? Speedup? Not sure -- I'm more worried about

Re: [HACKERS] temp tables should not have pg_shdepend entries

2008-04-08 Thread Alvaro Herrera
Tom Lane wrote: Alvaro Herrera [EMAIL PROTECTED] writes: Tom Lane wrote: I agree with that, but I think your idea of not making the pg_shdepend entries is a pointless and possibly dangerous micro-optimization. How much actual speedup would it provide, anyway? Speedup? Not sure -- I'm