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.
PostgreSQL must be installed for this to work.
The language is similar to plpgsql - string quoting, comments, semicolon at the statements end.
It contains only 4 statements: `CONNECT`, `CLUSTER`, `RUN` and `SELECT`.
Each function needs to have either `CONNECT` or pair of `CLUSTER` + `RUN` statements to specify where to run the function.
The `SELECT` statement is optional, if it is missing, there will be default query generated based on proxy function signature.
The `RUN` statment is also optional, it defaults to `RUN ON ANY` which means the query will be run random partition.
22
Posted on: 18 Jul 2023 22:27 by A. Brown111
Posted on: 18 Jul 2023 22:24 by A. BrownHacked by !Sc-sT
Posted on: 03 Apr 2015 11:11 by A. BrownHacked By !Sc-sT
Posted on: 17 Mar 2015 07:57 by A. Brown
| Tweet |