Re: Temporary tables and miscellaneous schemas

Sean Chittenden <sean@chittenden.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