On Sat, Sep 01, 2007 at 10:51:48PM -0400, Tom Lane wrote:
> David Fetter <[EMAIL PROTECTED]> 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.

David Fetter <[EMAIL PROTECTED]> 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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to