Re: Temporary tables and miscellaneous schemas

Sean Chittenden <sean(at)chittenden(dot)org> writes:
>> To take just one problem, the newbies who could use the "friendly
>> user" mode are very likely the same ones who do all their work as
>> postgres, because it hasn't occurred to them to create any
>> unprivileged users. They won't get the benefit of it if we make it
>> act as you suggest.

> Hrm, well, two flaws with that argument being:

> 1) Users who (ab)use DBA accounts aren't likely the ones with
> gazillions of pg_temp_* tables and probably don't even make use of
> temp tables or care about pg_toast. No harm, no foul, as the
> feature isn't likely used.

Perhaps, but you were arguing (I thought) for instituting a bunch of
differences in behavior between user and DBA modes, not only this one.

regards, tom lane