Skip site navigation (1) Skip section navigation (2)

plproxy - plproxy: More flexible CONNECT function.

From: mkz(at)pgfoundry(dot)org (User Mkz)
To: pgsql-committers(at)postgresql(dot)org
Subject: plproxy - plproxy: More flexible CONNECT function.
Date: 2009-09-15 12:21:39
Message-ID: (view raw or whole thread)
Lists: 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:
        cluster.c (r1.7 -> r1.8)
        function.c (r1.6 -> r1.7)
        parser.y (r1.14 -> r1.15)
        plproxy.h (r1.15 -> r1.16)
        plproxy_test.sql (r1.7 -> r1.8)
        plproxy_test.out (r1.7 -> r1.8)

pgsql-committers by date

Next:From: User MkzDate: 2009-09-15 12:31:57
Subject: plproxy - plproxy: docs for new CONNECT and dynamic queries
Previous:From: Michael MeskesDate: 2009-09-15 08:44:57
Subject: pgsql: Applied patch by Boszormenyi Zoltan <> to add

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group