Re: postgres function does not handle PUBLIC - expected?
| От | Szymon Guz |
|---|---|
| Тема | Re: postgres function does not handle PUBLIC - expected? |
| Дата | |
| Msg-id | AANLkTim+biVOvQyntTfSy+H_z1M58TPrLZtF8TrHvcsu@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: postgres function does not handle PUBLIC - expected? (Kasia Tuszynska <ktuszynska@esri.com>) |
| Ответы |
Re: postgres function does not handle PUBLIC -
expected?
|
| Список | pgsql-admin |
2010/8/10 Kasia Tuszynska <ktuszynska@esri.com>
Szymon,
The PUBLIC role is a default, non login role, that is created with every postgres cluster/instance.
To my knowledge PUBLIC is a standard user in any rdbms. So, existence of public is not the issue here.
Sincerely,
Kasia
No, there is no PUBLIC default role in ANY rdbms. In PostgreSQL there is PUBLIC schema, not role. In my PostgreSQL database there wasn't any such role... but I'll check that now... ok, I've checked, I've got 15 roles, none is names PUBLIC, what's more, I don't have any roles that cannot login.
run simple query: SELECT rolname FROM pg_roles; and check the existence of the PUBLIC role.
regards
Szymon Guz
В списке pgsql-admin по дате отправления: