Thread: Unable to enter money data in pgAdmin III's Edit Grid

Hey guys,

I have been using pgAdmin III for a while and it is a great tool so far.  However, I have this one problem since version 1.4  which may be a bug:

So, I created a column/field to be of type money.  When I try to enter an amount, i.e. 10.00, in the Edit Grid it gives an error "cannot cast numeric type to money".  When I try to type in '$10.00' the standard format for money, I cannot type in the ' (apostrophe) and $ (dollar symbol).  Thus, I cannot do anything but leave the field empty.

Is this a bug?  Or is there a setting/configuration that I missed somewhere?

Thanks!

-Trong

---

From: pgadmin-support-owner@postgresql.org [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Phuoc Trong Chu
Sent: 06 October 2006 23:06
To: pgadmin-hackers@postgresql.org; pgadmin-support@postgresql.org
Subject: [pgadmin-support] Unable to enter money data in pgAdmin III's Edit Grid

Hey guys,

I have been using pgAdmin III for a while and it is a great tool so far.  However, I have this one problem since version 1.4  which may be a bug:

So, I created a column/field to be of type money.  When I try to enter an amount, i.e. 10.00, in the Edit Grid it gives an error "cannot cast numeric type to money".  When I try to type in '$10.00' the standard format for money, I cannot type in the ' (apostrophe) and $ (dollar symbol).  Thus, I cannot do anything but leave the field empty.

Is this a bug?  Or is there a setting/configuration that I missed somewhere?

Thanks!

-Trong

On 10/4/06, Dave Page < dpage@vale-housing.co.uk> wrote:

I'm pleased to announce the second beta version of pgAdmin III v1.6.0 is
available for download in Source, Windows, Slackware and Mac OSX formats
from:

http://www.pgadmin.org/download/

This version contains various fixes for bugs reported in beta 1.

This is a beta version and may contain bugs - please test at your own
risk and report any bugs found to pgadmin-support@postgresql.org.

There are a huge number of improvements in pgAdmin 1.6 - for a complete
list, please see the changelog at:

http://www.pgadmin.org/development/changelog.php

Please note that translation work is still ongoing, therefore beta
releases may not include all the languages that pgAdmin eventually ships
with. If you are able to assist with the translation effort, please see
the status and HOWTO pages linked from:

http://www.pgadmin.org/translation/

Don't forget to let us know that you are working on a translation before
you start!!

Regards Dave
--
Dave Page
pgAdmin Project Lead

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

               http://archives.postgresql.org