Re: ODBC 7.1 - Mailing list pgsql-odbc

From Hiroshi Inoue
Subject Re: ODBC 7.1
Date
Msg-id 3B7352A7.EF2CD469@tpf.co.jp
Whole thread Raw
In response to Re: [SQL] ODBC 7.1  (Hiroshi Inoue <Inoue@tpf.co.jp>)
List pgsql-odbc
Keith Gray wrote:
>
> Hiroshi Inoue wrote:
> >
> > Keith Gray wrote:
> > >
> > > TOAST extensions. We have some documentation attached
> > > to fields which is up to 64kb.
> > >
> > > After upgrading the server I installed the current (7.1)
> > > ODBC driver for Win32.
> > >
> >
> > Is the version 7.01.0006 ?
>
> No... 7.01.0005

Please download the latest driver 7.01.0006.
Other drivers couldn't handle text fields > 8k.

>
> > > My write times are fairly slow. (significantly slower
> > > than 6.4/7.0)
>
> > Is the comparison for the < 8k data ?
>
> Without the large text attachment.
>
> > Is it as fast as 6.4/7.0 except concurrent write ?
>
> Not sure... lookups/queries are great (indexed and
> vacuum-analyzed) I think the write is slow... (and
> unsuccessful) because of a time-out.

Are you checking the 'Text as LongVarChar' driver option ?

regards,
Hiroshi Inoue

pgsql-odbc by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: [SQL] ODBC 7.1
Next
From: Tom Lane
Date:
Subject: Re: [GENERAL] Re: Bug#108286: case sensitivity in column names