Unix Technical Forum

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

This is a discussion on Unable to enter money data in pgAdmin III's Edit Grid within the pgsql Interfaces Pgadmin Support forums, part of the PostgreSQL category; --> Hey guys, I have been using pgAdmin III for a while and it is a great tool so far. ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Interfaces Pgadmin Support

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-17-2008, 08:34 PM
Phuoc Trong Chu
 
Posts: n/a
Default 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
>


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:12 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
www.UnixAdminTalk.com