I'm doing a low cost, low performance roll your own replication project, between various offices around Australia. The replication is asynchronous, and peer to peer. I've looked at the various replication projects, and for one reason or another, they're too hard.
My design uses jabber as middleware, using python scripts to do the hard work. However, it depends on triggers calling my python scripts to work. I can't find a way to call an external script from a trigger. I've searched the archives, and found a few other people asking the same question, but no answers (apart from the odd sanctimonious "well you shouldn't be doing that..." :-). I thought I was onto a winner with pgplsh, but I can't get it to compile with 7.3.4, although it compiled beautifully with 7.2.1. Using python as a trigger language also seems to be a non-starter, because the restricted python environment isn't yet working. So... Is there an easy way to call a script from a trigger? Thanks Alan Graham -- Alan Graham <[EMAIL PROTECTED]> ---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match