plproxy - plproxy: More flexible CONNECT function. - Mailing list pgsql-committers

From mkz@pgfoundry.org (User Mkz)
Subject plproxy - plproxy: More flexible CONNECT function.
Date
Msg-id 20090915122139.D07C11071E01@pgfoundry.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
More flexible CONNECT function.

It allows CONNECT to take function arguments or do function calls:

    CONNECT func(..);
    CONNECT argname;
    CONNECT $argnum;

NB: giving untrusted users ability to specify full connect string creates
security hole.  Eg it can real cleartext passwords from .pgpass/pg_service.
If such function cannot be avoided, it's access rights need to be restricted.

Patch by Ian Sollars

Modified Files:
--------------
    plproxy/src:
        cluster.c (r1.7 -> r1.8)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plproxy/plproxy/src/cluster.c?r1=1.7&r2=1.8)
        function.c (r1.6 -> r1.7)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plproxy/plproxy/src/function.c?r1=1.6&r2=1.7)
        parser.y (r1.14 -> r1.15)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plproxy/plproxy/src/parser.y?r1=1.14&r2=1.15)
        plproxy.h (r1.15 -> r1.16)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plproxy/plproxy/src/plproxy.h?r1=1.15&r2=1.16)
    plproxy/sql:
        plproxy_test.sql (r1.7 -> r1.8)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plproxy/plproxy/sql/plproxy_test.sql?r1=1.7&r2=1.8)
    plproxy/expected:
        plproxy_test.out (r1.7 -> r1.8)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plproxy/plproxy/expected/plproxy_test.out?r1=1.7&r2=1.8)

pgsql-committers by date:

Previous
From: meskes@postgresql.org (Michael Meskes)
Date:
Subject: pgsql: Applied patch by Boszormenyi Zoltan to add
Next
From: mkz@pgfoundry.org (User Mkz)
Date:
Subject: plproxy - plproxy: docs for new CONNECT and dynamic queries