Re: [GENERAL] [HACKERS] mirroring oracle database in pgsql

2005-06-13 Thread Jonah H. Harris
The contrib/dblink module only works for creating a database link to another PostgreSQL database. I'm working on a dblink_ora which allows you to connect to an 8i, 9i, or 10g system the same way. dblink_ora is based on dblink, not dblink_tds (for SQL Server) so it has more features. Also,

Re: [GENERAL] [HACKERS] mirroring oracle database in pgsql

2005-06-13 Thread Sean Davis
There is DBI-link, but this probably isn't an enterprise solution http://www.pervasive-postgres.com/postgresql/tidbits.asp Sean On Jun 13, 2005, at 2:31 PM, Jonah H. Harris wrote: The contrib/dblink module only works for creating a database link to another PostgreSQL database. I'm

Re: [GENERAL] [HACKERS] mirroring oracle database in pgsql

2005-06-13 Thread Jonah H. Harris
I wouldn't say it's enterprise-grade, but one could probably make it work. Sean Davis wrote: There is DBI-link, but this probably isn't an enterprise solution http://www.pervasive-postgres.com/postgresql/tidbits.asp Sean On Jun 13, 2005, at 2:31 PM, Jonah H. Harris wrote: The

Re: [GENERAL] [HACKERS] mirroring oracle database in pgsql

2005-06-13 Thread Sean Davis
On Jun 13, 2005, at 6:48 PM, Jonah H. Harris wrote: I wouldn't say it's enterprise-grade, but one could probably make it work. I totally agree--I use it relatively often. This single piece of software opened my eyes as to the extent to which the procedure languages can be leveraged.

Re: [GENERAL] [HACKERS] mirroring oracle database in pgsql

2005-06-12 Thread Christopher Kings-Lynne
Check out EnterprisDB: www.enterprisedb.com Chris Edward Peschko wrote: hey all, I'm trying to convince some people here to adopt either mysql or postgresql as a relational database here.. However, we can't start from a clean slate; we have a very mature oracle database that applications