From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: non unique value error... pgsql,,help needed. |
Date: | 2008-12-16 10:29:02 |
Message-ID: | 20081216102902.GG4557@a-kretschmer.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2008-12-16 10:47:43 | Re: pgsql: Append major version number and for libraries soname major |
Previous Message | Simon Riggs | 2008-12-16 10:21:10 | Re: Sync Rep: First Thoughts on Code |