pgAdmin III truncates numeric values in edit mode

From: Masoud Taherkhani <mtaherkhani(at)yahoo(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: pgAdmin III truncates numeric values in edit mode
Date: 2003-08-27 14:25:08
Message-ID: 20030827142509.28371.qmail@web21412.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Browse pgadmin-support by date

  From Date Subject
Next Message KOUEMY Doris Z. 2003-08-27 18:30:24 Help for create table with pgAdmin
Previous Message Dave Page 2003-08-27 13:51:46 Re: plugins in pgadmin III