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: 8568FC767B4AD311AC33006097BCD3D61A2D55@woody.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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 7.1.0.6
> 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?

Hi,

Yes this is a known bug in pgAdmin 7.1.0. It has been fixed in the CVS (at
www.greatbridge.org/project/pgadmin 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.

Browse pgsql-odbc by date

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