Its a JDBC based solution so all transfer is done through JDBC.
Regarding data types if you are using the same compatible data types between Oracle and PostgreSQL then all will go good. Thank you, ------------ Shoaib Mir EnterpriseDB (www.enterprisedb.com) On 11/29/06, Csaba Nagy <[EMAIL PROTECTED]> wrote:
On Wed, 2006-11-29 at 15:50, Shoaib Mir wrote: > It should be able to replicate to stock PostgreSQL as well but then > you will be having problems when replicating Oracle like data types to > PostgreSQL as EnterpriseDB is provided Oracle compatible features. Hmm, that's true, but that could be handled if the corresponding fields are convertible to each other. I'm not sure how slony is working, but if it would allow the data to be transmitted in it's text format and not binary, the data conversion could work just fine. Our corresponding fields in Oracle/postgres are mostly compatible, problems come in for boolean types mostly, and that can be solved by creating some implicit casts which solve the issue. So it all boils down on how the data is transferred, text or binary, and strictly typed or not... Cheers, Csaba.
_______________________________________________ Slony1-general mailing list [email protected] http://gborg.postgresql.org/mailman/listinfo/slony1-general
