Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL

2022-06-22 Thread Jagmohan Kaintura
Hi ALl, Any other thought on this thread. On Tue, Jun 21, 2022 at 2:24 PM Gilles Darold wrote: > Le 21/06/2022 à 10:28, Jagmohan Kaintura a écrit : > > Hi Gilles, > > I was going though this earlier today but didn't compiled it as I read it > may not be able to capture the errors if we have bel

Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL

2022-06-21 Thread Gilles Darold
Le 21/06/2022 à 10:28, Jagmohan Kaintura a écrit : Hi Gilles, I was going though this earlier today but didn't compiled it as I read it may not be able to capture the errors if we have below type of statement and most of our statements are of INSERT .. SELECT statements only. The form |INSE

Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL

2022-06-21 Thread Jagmohan Kaintura
Hi Gilles, I was going though this earlier today but didn't compiled it as I read it may not be able to capture the errors if we have below type of statement and most of our statements are of INSERT .. SELECT statements only. The form INSERT INTO SELECT ... will not have the same behavior than i

Re: INSERT ALL with DML ERROR Logging replacement in PostgreSQL

2022-06-21 Thread Gilles Darold
Le 21/06/2022 à 09:08, Jagmohan Kaintura a écrit : Hi Team, We are working on a project where we are moving from Oracle to PostgreSQL and working on a migration tool which mostly have statements for inserting the records which are correct and logging the errors in error table using ORACLE inbu

INSERT ALL with DML ERROR Logging replacement in PostgreSQL

2022-06-21 Thread Jagmohan Kaintura
Hi Team, We are working on a project where we are moving from Oracle to PostgreSQL and working on a migration tool which mostly have statements for inserting the records which are correct and logging the errors in error table using ORACLE inbuilt statement for INSERT ALL with DML ERROR logging. As