> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
