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 values with numeric(38) field. > > for eg. > > column: a numeric(38) primary > > giving me error of non unique value in following two data. > 1. 111122223333444455556666777788889999 > 2. 111122223333444455556666777788889997 (<----- both are different.) > > When i enter first data into column (using EMS SQL MANAGER),it converts it > to 1.11122223333444E35
Can you try to insert such values with plain psql? I have tried that and it works without trouble: test=# create table foo (id serial, n numeric(38)); NOTICE: CREATE TABLE will create implicit sequence "foo_id_seq" for serial column "foo.id" CREATE TABLE test=*# insert into foo (n) values (111122223333444455556666777788889999); INSERT 0 1 test=*# select * from foo; id | n ----+-------------------------------------- 1 | 111122223333444455556666777788889999 (1 row) test=*# insert into foo (n) values (111122223333444455556666777788889997); INSERT 0 1 test=*# select * from foo; id | n ----+-------------------------------------- 1 | 111122223333444455556666777788889999 2 | 111122223333444455556666777788889997 (2 rows) test=*# Which version do you have? I think, it's a problem with EMS SQL MANAGER, but i don't know that tool. Regards, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
