Issue with editing float8 fields

From: "Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Issue with editing float8 fields
Date: 2006-09-29 12:48:52
Message-ID: 53F9CF533E1AA14EA1F8C5C08ABC08D2EFB6C9@ZDND.DND.boston.cob
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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.

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'


As far as I can tell, there is nothing I can put in that field that
would work.
If I try to edit from Microsoft Access using the ODBC driver as a linked
table, I can edit the field fine.

As a general note I see that according to the table header, the field is
being treated as a double precision for editing purposes.

-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally
privileged and/or exempt from disclosure pursuant to Massachusetts
law. It is intended
solely for the addressee. If you received this in error, please
contact the sender and
delete the material from any computer.

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2006-09-29 13:03:32 Re: Issue with editing float8 fields
Previous Message Obe, Regina 2006-09-29 12:18:39 Re: My Sequence does not increment what I expected