Re: [HACKERS] non unique value error... pgsql,,help needed.

2008-12-16 Thread Tom Lane
Shri writes: > When i enter first data into column (using EMS SQL MANAGER),it converts it > to 1.111444E35 I think you need to complain to EMS. regards, tom lane PS: this is not a hacker-grade question. -- Sent via pgsql-hackers mailing list (pgsql-hackers@post

Re: [HACKERS] non unique value error... pgsql,,help needed.

2008-12-16 Thread A. Kretschmer
In response to Shri : > Dear friends, > > I am trying to import db from oracle to pgsql, > > meanwhile facing a difficulty during importing oracle numeric(38) to pgsql > numeric(38) column, Because in oracle that column is unique, but PGsql not > able > to correctly identify different and unique

[HACKERS] non unique value error... pgsql,,help needed.

2008-12-16 Thread Shri
Dear friends, I am trying to import db from oracle to pgsql, meanwhile facing a difficulty during importing oracle numeric(38) to pgsql numeric(38) column, Because in oracle that column is unique, but PGsql not able to correctly identify different and unique values with numeric(38) field. for eg.