Sven Willenberger <sven@xxxxxxx> writes: > We have a replication set up between 2 servers using Slony; both are > runnind PostgreSQL 8.0.1. The issue is that when updates/inserts are > made to a replicated table, the replication does not occur; apparently > this is due to spi_exec somehow not allowing/causing the slony trigger > function to fire. Yuck :-(. The only idea that comes to mind is that 8.0 changed the timing of trigger firing --- the triggers are probably firing while your function still has control, whereas in earlier releases they'd only fire after it returns. Could this be breaking some assumption Slony makes about the order of operations? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
