Jeff, Thanks for the reply, can you let us know how we get the values for the function inputs p_start , p_txid ?
Regards, Nimesh. On Thu, Nov 5, 2009 at 7:49 PM, Jeff <[email protected]> wrote: > > On Nov 5, 2009, at 12:09 AM, Nimesh Satam wrote: > > All, >> >> Is there any way to confirm that a certain insert has been completed on >> the slave database? Would the sl_confirm or sl_event table be useful for >> this? >> >> For eg: If I have a batch of 100 Inserts, how do I make sure that all have >> been done on slave? >> >> Regards, >> Nimesh. >> > > > I've got this code which seems to work well. I added a function to my DB > access layer called "syncexec" that executes and waits for the slaves (up to > a predefined interval). > > You'll need to do your work inside a transaction and get the txn's txnid > for this to work (you can obtain it via _cluster.getCurrentXid() > > > > > -- > Jeff Trout <[email protected]> > http://www.stuarthamm.net/ > http://www.dellsmartexitin.com/ > > > > >
_______________________________________________ Slony1-general mailing list [email protected] http://lists.slony.info/mailman/listinfo/slony1-general
