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 <threshar at torgo.978.org> 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 ha=
ve
>> 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 <jeff at jefftrout.com>
> http://www.stuarthamm.net/
> http://www.dellsmartexitin.com/
>
>
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20091112/=
f234131c/attachment.htm