On Sat, Sep 01, 2007 at 10:51:48PM -0400, Tom Lane wrote:
> David Fetter <david@fetter.org> writes:
> > While we're at it, it would be very nice to be able to set default
> > per-role, per-database settings.
>
> Er ... what deficiency do you see in ALTER ROLE SET and ALTER DATABASE SET?
You can't set both at once. Let's imagine that you have two databases
in a cluster: foo with schemas foo_1 and foo_2, and bar with schemas
bar_1 and bar_2. There's no way (currently) to set a ROLE's foo
search_path to foo_1,foo_2 and its bar search_path to bar_1, bar_2.
Cheers,
David.
--
David Fetter <david@fetter.org> http://fetter.org/
phone: +1 415 235 3778 AIM: dfetter666 Skype: davidfetter
Remember to vote!
Consider donating to PostgreSQL: http://www.postgresql.org/about/donate
