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 <nagy at ecircle-ag.com> 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.
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://gborg.postgresql.org/pipermail/slony1-general/attachments/20061129/a29c277b/attachment.html