Re: Issue with editing float8 fields - Mailing list pgadmin-support

From Dave Page
Subject Re: Issue with editing float8 fields
Date
Msg-id E7F85A1B5FF8D44C8A1AF6885BC9A0E40176D194@ratbert.vale-housing.co.uk
Whole thread Raw
In response to Issue with editing float8 fields  ("Obe, Regina" <robe.dnd@cityofboston.gov>)
List pgadmin-support

> -----Original Message-----
> From: pgadmin-support-owner@postgresql.org
> [mailto:pgadmin-support-owner@postgresql.org] On Behalf Of Obe, Regina
> Sent: 29 September 2006 13:49
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Issue with editing float8 fields
>
> I'm guessing float8 is deprecated since I don't see it in the list of
>
> options when creating fields.  I have an older table that has
> a field of
>
> type float8.

No, pgAdmin just uses the SQL spec name now which is "double precision".
See
http://www.postgresql.org/docs/8.1/interactive/datatype.html#DATATYPE-TA
BLE for a more complete list.

>
> I'm using PgAdmin III 1.6 Beta 1, Sep 12 2006, rev: 5353 on a windows
>
> 2000 machine.
>
> When I try to edit data in this table -> editing the float8 field,  it
>
> gives me an error
>
>
> 'syntax error at or near "precision" at character 51'
>

Please try the newer snapshot at:
http://developer.pgadmin.org/snapshots/win32/pgadmin3-20060921-Win32.zip
. The bug you see has been fixed.

Regards, Dave.


pgadmin-support by date:

Previous
From: "Obe, Regina"
Date:
Subject: Issue with editing float8 fields
Next
From: Dave Page
Date:
Subject: Re: View data comes up empty