Why an array in pg_group?
| От | Reinoud van Leeuwen |
|---|---|
| Тема | Why an array in pg_group? |
| Дата | |
| Msg-id | 20021120130318.D91635@spoetnik.xs4all.nl обсуждение исходный текст |
| Ответы |
Re: Why an array in pg_group?
|
| Список | pgsql-hackers |
Hi, Is there any reason why the grolist field in the table pg_group is implemented as an array and not as a separate table? According to the documentation: <quote source="Postgresql 7.2 User Manual, chapter 6 near the end"> Arrays are not sets; using arrays in the manner described in the previous paragraph is often a sign of database misdesign. </quote> I have trouble implementing a way to easily check whether a user is part of a group. (I use Apache::AuthDBI to implement authentication and wanted to make a view with columns username, userid , groupname. And installing the contrib/array give's me a postgresql that is different from all the others :-( -- __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen reinoud.v@n.leeuwen.net http://www.xs4all.nl/~reinoud __________________________________________________
В списке pgsql-hackers по дате отправления: