error with " DECLARE nss_pgsql_internal_allusers_curs SCROLL CURSOR FOR FOR READ ONLY"

Hi all,

I'm using libnss_pgsql module but there's problems with it. If I exute
"getent passwd", the following messages show
in /var/lib/pgsql/data/pg_log/postgresql-Sat.log. And the system is still
using /etc/passwd and /etc/group to authenticate ssh uses.

ERROR: syntax error at or near "FOR" at character 61
> STATEMENT: DECLARE nss_pgsql_internal_allusers_curs SCROLL CURSOR FOR
> FOR READ ONLY
> ERROR: current transaction is aborted, commands ignored until end of
> transaction block
> STATEMENT: FETCH FROM nss_pgsql_internal_allusers_curs

Eveny I modify codes nss-pgsql.conf like:

> getpwnam = SELECT login AS
> username,passwd,gecos,('/var/lib/gforge/chroot/home/users/' || login) AS
> homedir,shell,uid,gid FROM nss_passwd WHERE login = $1

to

> getpwnam = SELECT AS
> ,passwd,gecos,('/var/lib/gforge/chroot/home/users/' || login) AS
> homedir,shell,uid,gid FROM nss_passwd WHERE login = $1

The previous error message would show. I can't figure out why. Can anyone
give some advice? Thanks!

(the link of original post is http://lists.alioth.debian.org/pipermail/nsspampgsql-devel/2012-April/000812.html)