Re: pgAdmin III truncates numeric values in edit mode

-----Original Message-----
From: Masoud Taherkhani [mailto:mtaherkhani@yahoo.com]
Sent: 27 August 2003 15:25
To: pgadmin-support@postgresql.org
Subject: [pgadmin-support] pgAdmin III truncates numeric values in edit mode

Hi:

 

1- I created the following table in pgAdmin III :

 

CREATE TABLE public.test (

exchng_rt numeric);

2- Then inserted a record in the table using

INSERT INTO test VALUES (1.5151515151515151515151515152);

3- SELECT * FROM test; returned correct data.

4- Then I right clicked on test table and selected View Data.

5- I double clicked on exchng_rt field but didn't make any changes. It changed the value to 1.515152

6- SELECT * FROM test; returned 1.515152

FYI, I am using Windows 2000 Professional, pgAdmin III Version 0.9.0 BETA 1 (Aug 6 2003) English version.

Thanks,

Masoud Taherkhani

---

Post your free ad now! Yahoo! Canada Personals