Re: Migrating from Oracle - Implicit Casting Issue

2022-07-19 Thread Karthik K L V
Hi David, Thanks for the quick response. Making sure I got it right - U mean Postgres DB Server when you say server right? IIUC, by configuring this property, the driver will not set the type and leave it to the Postgres DB Server to map it to the appropriate type. Will this have any performance i

Migrating from Oracle - Implicit Casting Issue

2022-07-18 Thread David G. Johnston
On Monday, July 18, 2022, Karthik K L V wrote: > Hi Team, > > We are migrating from Oracle 12c to Aurora Postgres 13 and running into > implicit casting issues. > > Oracle is able to implicitly cast the bind value of prepared statements > executed from the application to appropriate type - String

Migrating from Oracle - Implicit Casting Issue

2022-07-18 Thread Karthik K L V
Hi Team, We are migrating from Oracle 12c to Aurora Postgres 13 and running into implicit casting issues. Oracle is able to implicitly cast the bind value of prepared statements executed from the application to appropriate type - String -> Number, String -> Date, Number -> String etc. when there