From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
Cc: | pgsql-odbc(at)postgresql(dot)org, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org> |
Subject: | Re: [HACKERS] ODBC Driver int8 Patch |
Date: | 2001-01-23 16:14:12 |
Message-ID: | 200101231614.LAA10067@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc pgsql-patches |
I am waiting for someone to comment on this. Anyone?
[ Charset ISO-8859-1 unsupported, converting... ]
> Hi Bruce,
>
> Did you accept this patch in the end or was it rejected?
>
> Regards, Dave.
>
> > -----Original Message-----
> > From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> > Sent: 16 January 2001 16:50
> > To: Dave Page
> > Cc: 'pgsql-hackers(at)postgresql(dot)org'
> > Subject: Re: [HACKERS] ODBC Driver int8 Patch
> >
> >
> > As I remember, the problem is that this makes us match the
> > ODBC v2 spec,
> > but then we would not match the v3 spec. Is that correct?
> >
> >
> > [ Charset ISO-8859-1 unsupported, converting... ]
> > > Hi,
> > >
> > > It was suggested that I post this patch here as no notice
> > was taken of it
> > > when posted to interfaces!
> > >
> > > This fixes problems with int8 columns which are reported by
> > the driver as
> > > SQL_BIGINT rather than SQL_CHAR as per the ODBC v2 spec.
> > Specifically, I
> > > have had problems with MS ADO - any queries that contain an
> > int8 column in
> > > the resultset will *always* return an empty recordset.
> > >
> > > Regards,
> > >
> > > Dave.
> > >
> > > *** pgtypes.c.orig Fri Dec 22 09:12:22 2000
> > > --- pgtypes.c Fri Dec 22 09:12:22 2000
> > > ***************
> > > *** 217,223 ****
> > > case PG_TYPE_XID:
> > > case PG_TYPE_INT4: return SQL_INTEGER;
> > >
> > > ! case PG_TYPE_INT8: return SQL_BIGINT;
> > > case PG_TYPE_NUMERIC: return SQL_NUMERIC;
> > >
> > > case PG_TYPE_FLOAT4: return SQL_REAL;
> > > --- 217,223 ----
> > > case PG_TYPE_XID:
> > > case PG_TYPE_INT4: return SQL_INTEGER;
> > >
> > > ! case PG_TYPE_INT8: return SQL_CHAR;
> > > case PG_TYPE_NUMERIC: return SQL_NUMERIC;
> > >
> > > case PG_TYPE_FLOAT4: return SQL_REAL;
> > >
> >
> >
> > --
> > Bruce Momjian | http://candle.pha.pa.us
> > pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
> > + If your life is a hard drive, | 830 Blythe Avenue
> > + Christ can be your backup. | Drexel Hill,
> > Pennsylvania 19026
> >
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | Joseph | 2001-01-23 16:21:23 | Error 3669 in access 97 using odbc |
Previous Message | Bruce Momjian | 2001-01-23 15:12:41 | Re: RE: Driver updates for 7.1 |
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2001-01-23 16:32:23 | Re: [PATCHES] Re: [HACKERS] ODBC Driver int8 Patch |
Previous Message | Bruce Momjian | 2001-01-23 15:11:38 | Re: Support for cursors in PL/pgSQL |