Re: synchronous_commit: Developer's View

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