[Nsspampgsql-devel] Bug#500890: libnss-pgsql2: Wrong SQL querys in nss-pgsql.conf

[Herwin Weststrate]

The solution of Torsten would imply that only the users who have the
given group as a primary group are listed as the groupmembers.

The attached patch uses the join-table, and only the join-table. This
means things would break if users have this group as primary group but
aren't listed in the usergroups table. It's possible to add an OR/UNION
to the query to select these members too. (In my situation it's not
required, but I don't know what the current best-practice is to store
this.)

Herwin
-------------- next part --------------
A non-text attachment was scrubbed...
Name: nss-pgsql.conf.patch
Type: text/x-diff
Size: 1870 bytes
Desc: not available
Url : http://lists.alioth.debian.org/pipermail/nsspampgsql-devel/attachments/20081024/c79104f1/attachment.patch