Re: [ADMIN] Migration from Postgresql 9 to Oracle 10g

2012-10-18 Thread Grant Allen
On 18/10/2012 23:31, Craig Ringer wrote: > On 10/19/2012 01:46 AM, Grant Allen wrote: >> On 18/10/2012 02:13, Shams Khan wrote: >>> Hi Experts, >>> >>> I am in the process of migration from PG 9 to oracle. All of the >>> database objects has been migrated apart from functions. The main >>> issue I

Re: [ADMIN] Migration from Postgresql 9 to Oracle 10g

2012-10-18 Thread Craig Ringer
On 10/19/2012 01:46 AM, Grant Allen wrote: On 18/10/2012 02:13, Shams Khan wrote: Hi Experts, I am in the process of migration from PG 9 to oracle. All of the database objects has been migrated apart from functions. The main issue I am facing with function code where DML statements are used in

Re: [ADMIN] Migration from Postgresql 9 to Oracle 10g

2012-10-18 Thread Grant Allen
On 18/10/2012 02:13, Shams Khan wrote: > Hi Experts, > > I am in the process of migration from PG 9 to oracle. All of the > database objects has been migrated apart from functions. The main > issue I am facing with function code where DML statements are used in > the code. On the other side, Oracl

Re: [ADMIN] Migration from Postgresql 9 to Oracle 10g

2012-10-18 Thread m...@trausch.us
On 10/18/2012 05:02 AM, fr...@frank.uvena.de wrote: > Am 2012-10-18 10:31, schrieb Gabriele Bartolini: > >> Just for the record and to understand if this is due to PostgreSQL >> limitations, are you in a position to give us technical/product >> reasons for this decision? > > I'd like to also know

Re: [ADMIN] Migration from Postgresql 9 to Oracle 10g

2012-10-18 Thread frank
Am 2012-10-18 10:31, schrieb Gabriele Bartolini: Just for the record and to understand if this is due to PostgreSQL limitations, are you in a position to give us technical/product reasons for this decision? I'd like to also know reasons for this Cheers, Frank -- Sent via pgsql-admin mai

Re: [ADMIN] Migration from Postgresql 9 to Oracle 10g

2012-10-18 Thread Gabriele Bartolini
Hi Shams, On Thu, 18 Oct 2012 11:43:52 +0530, Shams Khan wrote: I am in the process of migration from PG 9 to oracle. All of the database objects has been migrated apart from functions. The main issue I am facing with function code where DML statements are used in the code. On the other side,

Re: [ADMIN] Migration from Postgresql 9 to Oracle 10g

2012-10-18 Thread Albe Laurenz
Maybe you will get more enthusiastic support in an Oracle forum... It is curious that you want to migrate form a fairly current PostgreSQL version (you didn't say which one) to an Oracle version that is already out of (Premier) support and will be terminally abandoned next year. Shams Khan wrote:

[ADMIN] Migration from Postgresql 9 to Oracle 10g

2012-10-17 Thread Shams Khan
Hi Experts, I am in the process of migration from PG 9 to oracle. All of the database objects has been migrated apart from functions. The main issue I am facing with function code where DML statements are used in the code. On the other side, Oracle doesn't support DML's in functions or procedures.