Обсуждение: variables during creation of a role

Поиск
Список
Период
Сортировка

variables during creation of a role

От
Jean-Max Reymond
Дата:
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 ?


Re: variables during creation of a role

От
Dave Page
Дата:
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.