Re: Temporary tables and miscellaneous schemas - Mailing list pgsql-general

From Tom Lane
Subject Re: Temporary tables and miscellaneous schemas
Date
Msg-id 15124.1067294094@sss.pgh.pa.us
Whole thread Raw
In response to Re: Temporary tables and miscellaneous schemas  (Sean Chittenden <sean@chittenden.org>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Dave Cramer
Date:
Subject: grant all to database inheritence
Next
From: "Rada Chirkova"
Date:
Subject: What is an RT index?