Hi Christopher, first let me say that I really grateful for your help, and I 
have some question. I have just reviewed the code of slony1_funcs.c, and I 
recognize where the information about the operation is.



But my question is How I can catch the part of the sentences corresponding 
at the where in the case of update or delete if this part exist in the 
sentence? Or if is possible identify this information using this function?



Thanks in advanced.

Atte. Manuel

----- Original Message ----- 

From: "Christopher Browne" <cbbrowne at ca.afilias.info>
To: "Manuel Garc?a" <mgarciah at ife.org.mx>
Cc: <slony1-general at gborg.postgresql.org>
Sent: Tuesday, May 31, 2005 9:49 AM
Subject: Re: [Slony1-general] Can i replycate from postgresql to oracle?


> Manuel Garc?a wrote:
>
>> Hi, I need some advices, maybe somebody can help me. I need to
>> replicate some tables that are in different servers, all that servers
>> using PostgreSql 7.3 , I need consolidate all information inside many
>> tables that are allocated on Oracle, but I need to apply only the
>> changes because If I insert all the information my process take around
>> 3 or more hours. Then I need to consolidate all the information
>> applying only the movements that I don?t apply yet.
>>
>> Somebody can tell me if I can use the slony1 to do that? and what is
>> the level of confidence using this mechanism to assure the integrity
>> of my information?
>>
>> Thanks in advanced.
>>
> Slony-I is designed for use with PostgreSQL; there has not been any
> particular thought put into making it able to support Oracle.
>
> If you were prepared to do a LOT of hacking around with the code in
> slon, it would quite likely be possible to come up with something that
> could write data into an Oracle database. This would require that you
> get to know the code of slon well enough that you would have little need
> to ask questions on this mailing list!
>
> Version 1.1 (coming Real Soon Now(tm)) has a "log shipping" facility
> that might make the task of writing data into an Oracle database involve
> a lot less "surgery." With "log shipping," the updates are all
> serialized into files on disk, and are Plain Ordinary Queries. They
> become plain INSERT, UPDATE, and DELETE statements.
>
> You would likely need to modify the header/footer of each log file, but
> that should be a pretty easy task using any old scripting language.
>
> But that's also assuming that the operating model of Slony-I is
> consistent with how you need data to be replicated...
> -- 
> <http://linuxdatabases.info/info/slony.info>