how to use pam-pgsql

I declare a cursor as below:
DECLARE
links_cur SCROLL CURSOR IS SELECT * FROM road;

and get this error:
CONTEXT: invalid type name "SCROLL CURSOR IS SELECT * FROM road"

If I take away 'SCROLL', it has no problem.

Any hint?

Thanks,
cyw

<cyw@dls.net> writes:

I declare a cursor as below:
DECLARE
links_cur SCROLL CURSOR IS SELECT * FROM road;
and get this error:
CONTEXT: invalid type name "SCROLL CURSOR IS SELECT * FROM road"

What PG version? IIRC plpgsql didn't allow the SCROLL modifier there
before 8.3.

regards, tom lane

Am 2008-10-06 12:28:28, schrieb Dejan Dimic:

Does anyone know how to set vsftpd to work with pam-pgsql for user
authentification or how to use pam-pgsql at all.

Does "vsftpd" support PAM?

If yes you have to configure PAM to use pgSQL. ;-)

What about reading the documentation?

The SQL SCHEME is included in the tarball so create a database like
"system" and load the *.sql file into it. Now you can add normal unix
users to it.

Thanks, Greetings and nice Day/Evening
Michelle Konzack
Systemadministrator
24V Electronic Engineer
Tamay Dogan Network
Debian GNU/Linux Consultant

-- 
Linux-User #280138 with the Linux Counter, http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
+49/177/9351947    50, rue de Soultz         MSN LinuxMichi
+33/6/61925193     67100 Strasbourg/France   IRC #Debian (irc.icq.com)

On Oct 8, 2:52 am, linux4miche...@tamay-dogan.net (Michelle Konzack)
wrote:

Am 2008-10-06 12:28:28, schrieb Dejan Dimic:

Does anyone know how to set vsftpd to work with pam-pgsql for user
authentification or how to use pam-pgsql at all.

Does "vsftpd" support PAM?

If yes you have to configure PAM to use pgSQL.  ;-)

What about reading the documentation?

The SQL SCHEME is included in the tarball  so  create  a  database  like
"system" and load the *.sql file into it.  Now you can add  normal  unix
users to it.

Thanks, Greetings and nice Day/Evening
    Michelle Konzack
    Systemadministrator
    24V Electronic Engineer
    Tamay Dogan Network
    Debian GNU/Linux Consultant

--
Linux-User #280138 with the Linux Counter,http://counter.li.org/
##################### Debian GNU/Linux Consultant #####################
Michelle Konzack   Apt. 917                  ICQ #328449886
+49/177/9351947    50, rue de Soultz         MSN LinuxMichi
+33/6/61925193     67100 Strasbourg/France   IRC #Debian (irc.icq.com)

 signature.pgp
< 1KViewDownload

Thanks, for your reply.
I have managed to make it work in the meantime :-)
Reading the documentation can be very informative.
There is a ton of mysql documentation but for postgresql not so many.