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

RE: Error with DECIMAL or NUMERIC data type

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'Ryan C(dot) Bonham'" <Ryan(at)srfarms(dot)com>, pgsql-odbc(at)postgresql(dot)org
Subject: RE: Error with DECIMAL or NUMERIC data type
Date: 2001-07-30 07:11:33
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-odbc

> -----Original Message-----
> From: Ryan C. Bonham [mailto:Ryan(at)srfarms(dot)com] 
> Sent: 27 July 2001 14:47
> To: pgsql-odbc(at)postgresql(dot)org
> Subject: [ODBC] Error with DECIMAL or NUMERIC data type
> Hi,
> I am receiving an error message when i try connecting to a 
> table on my postgresql database via PGAdmin. The fileds that 
> give me a problem are all NUMERIC data types, i tried 
> changing them to DECIMAL and there is no difference. The 
> error i see on the screen is. 
> Error 6
> Overflow
> Function: frmTables, trvBrowser_NodeClick
> This table also crashes Visual Basic 6.0sp6 if i try to 
> create a connection to it.. 
> I am using Postgres ODBC driver version
> I am using PGADMIN version 7.1.0
> I am using postgres version 7.1.1 (RPM based install)
> I attached my pgadmin.log and also the psqlodbc.log
> Is this a known problem? If so what's the work arround, if 
> not what should i do to try and fix it?


Yes this is a known bug in pgAdmin 7.1.0. It has been fixed in the CVS (at if you wish to try it) and will also be
in 7.1.1. I don't know why your VB also crashes.

Regards, Dave.

pgsql-odbc by date

Next:From: Dave PageDate: 2001-07-30 07:19:38
Subject: RE: [ODBC] Visual Basic and PostgreSQL ODBC
Previous:From: Andre SchnabelDate: 2001-07-28 07:15:24
Subject: Re: Visual Basic and PostgreSQL ODBC

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