From 7b750ae4eeb8e18db092f0cde81f4598885e015a Mon Sep 17 00:00:00 2001 From: Marko Kreen Date: Tue, 10 Nov 2009 13:36:24 +0000 Subject: [PATCH] doc update: add ver tags to few places --- doc/syntax.txt | 10 +++++++--- doc/todo.txt | 1 - 2 files changed, 7 insertions(+), 4 deletions(-) diff --git a/doc/syntax.txt b/doc/syntax.txt index 72de3c6..689b433 100644 --- a/doc/syntax.txt +++ b/doc/syntax.txt @@ -28,8 +28,9 @@ If several functions have same connstr, they will use same connection. Connect string is taken from function result or directly from argument. If several functions have same connstr, they will use same connection. +_(New in 2.0.9)_ -NB: giving untrusted users ability to specify full connect string creates +*NB*: giving untrusted users ability to specify full connect string creates security hole. Eg it can used to read cleartext passwords from `~/.pgpass` or `pg_service.conf`. If such function cannot be avoided, it's access rights need to be restricted. @@ -69,7 +70,7 @@ tagged, query will be sent in parallel to them. RUN ON argname; RUN ON $1; -Take hash value directly from function argument. +Take hash value directly from function argument. _(New in 2.0.8)_ == SPLIT == @@ -80,6 +81,7 @@ Split the input arrays based on RUN ON statement into per-partition arrays. This is done by evaluating RUN ON condition for each array element and building per-partition parameter arrays for each matching partition. During execution each tagged partition then gets its own subset of the array to process. +_(New in 2.1)_ The semantics of RUN ON statement is slightly changed with SPLIT arrays: @@ -151,7 +153,9 @@ Everything that is not argument reference is just passed on. PL/Proxy supports function returning plain RECORD type. Such functions need the result type specified at call site. Main use-case is to run -random queries on partitions. Very simple example: +random queries on partitions. _(New in 2.0.6)_ + +Very simple example: CREATE OR REPLACE FUNCTION dynamic_query(q text) RETURNS SETOF RECORD AS $$ diff --git a/doc/todo.txt b/doc/todo.txt index 16ed61e..e8f9e5b 100644 --- a/doc/todo.txt +++ b/doc/todo.txt @@ -15,7 +15,6 @@ * Drop plproxy.get_cluster_config()... - * Dynamic connstr loading for CONNECT functions? * RUN ON ALL: sort by? * RUN ON ALL: ignore errors? * RUN ON ANY: if one con failed, try another -- 2.39.5