Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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.


pgadmin-support by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group