On 21 Jan 2004 at 14:50, Milan Babuskov wrote:

>> ------ Begin Pseudo ------
>> The 'Collector' queries each database, and retrieves any new changes.
>
>How do you plan on doing this?
>You can have a single one column table with one value: last replicated
>generator_id. Then just query each table if it has gen_id larger than
>that number.

I'm afraid this approach will fail with long-living transactions.
Some ids below last replicated id may be not replicated if they
weren't commited at the replication moment.

SY, Dimitry Sibiryakov.