Skip to content

use of function only updates node where function is called #7

Closed
Slania opened this Issue Feb 28, 2016 · 1 comment

2 participants

@Slania
Slania commented Feb 28, 2016

functions don t work

As you can see, simple table with an insert function. Only applies the function to the node I called the function from. Also, it doesn't matter if the other node has the function or not. I understand this might be because of no support for distributed transactions and that functions are inherently transactional but there is no warning or error message for the same.

@marcocitus
Citus Data member

This is currently addressed in the develop branch (version 0.2):
https://github.com/citusdata/pg_paxos/tree/develop

Instead of logging the literal query string, this version deparses the query plan, which gives it the query as it is meant to be executed after evaluating parameters. However, since the deparser (from ruleutils.c in postgres) doesn't deparse all query plans correctly, this version breaks some other (complex) queries.

@marcocitus marcocitus referenced this issue Mar 6, 2016
Merged

pg_paxos 0.2 #9

@marcocitus marcocitus closed this in #9 Mar 6, 2016
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.