From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Issue with editing float8 fields |
Date: | 2006-09-29 13:03:32 |
Message-ID: | E7F85A1B5FF8D44C8A1AF6885BC9A0E40176D194@ratbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: pgadmin-support-owner(at)postgresql(dot)org
> [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of Obe, Regina
> Sent: 29 September 2006 13:49
> To: pgadmin-support(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2006-09-29 18:53:56 | Re: View data comes up empty |
Previous Message | Obe, Regina | 2006-09-29 12:48:52 | Issue with editing float8 fields |