PL/Proxy free download, PL/Proxy download on software download

A free database partitioning system implemented as PL language PL/Proxy is a free and open source proxy language used for remote database procedure calls and data partitioning between databases based on hashing field values.Main idea is that proxy function will be created with same signature as remote function to be called, so only destination info needs to be specified inside proxy function body. PL/Proxy is a compact language for remote calls between PostgreSQL databases. Syntax is similar to PL/pgSql and language contains only 4 statements.With PL/Proxy the user can create proxy functions that have same signature as remote functions to be called. The function body describes how the remote connection should be acquired. Here are some key features of "PL/Proxy": · PL/Proxy functions detect remote functions to be called from their own signature. · Function can be run on one, some or all members of the cluster. · If query is executed on several partitions, it will happen in parallel. · Queries are run in auto-commit mode on the remote server. · Query parameters are sent separately from query body, thus avoiding quoting/unquoting overhead on both sides. · If proxy and partition backend versions match, PL/Proxy tries to use binary I/O if possible. What's New in This Release: · Avoid parsing "SELECT (" as function call. Otherwise following query · fails to parse: SELECT (0*0); · (Peter Eisentraut) · Make scanner accept dot as standalone symbol. Otherwise following query · fails to parse: SELECT (ret_numtuple(1)).num, (ret_numtuple(1)).name; · (Peter Eisentraut) · Argument type name length over 32 could cause buffer overflow. · (Ian Sollars) · Fix crash with incoming NULL value in function containing SELECT · with different argument order. Due to thinko, NULL check was done · with query arg index, instead of function arg index. · (Jo?o Matos) · geterrcode(): Switch memory context to work around Assert() in CopyErrorData().

PL/Proxy Related Software