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. Cheers, David. -- 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
