SEO

#1 (**permalink**) 04-17-2008, 08:13 PM

Hi,
when I create a role with pgadmin3, variables (like search_path) are not
enabled in the select menu. I have to create the role and then all the
variables are allowed. Is this behavior a normal way ?

#2 (**permalink**) 04-17-2008, 08:13 PM

Jean-Max Reymond wrote:
> Hi,
> when I create a role with pgadmin3, variables (like search_path) are not
> enabled in the select menu. I have to create the role and then all the
> variables are allowed. Is this behavior a normal way ?

That was changed for 1.8.0:

2007-09-24 DP 1.8.0 Allow GUCs to be set on users, roles and databases
at create time.

I assume you're running an older version?

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

variables during creation of a role