New release?

I'll be bundling PostgreSQL 8.2 for Windows tomorrow and want to include
an updated psqlODBC build. Please shout ASAP if there is a good reason
why I shouldn't build psqlODBC 08.02.0200 for inclusion!

Regards Dave.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: New release?

i have an open issue in 8.2b1 with psqlOdbc 8.2.02 (paged recordset-query
that "crashes"), but unfortunately due to more severe 8.2b1 problems i
wasn't yet able to gather data and report it properly. i've switched to an
older driver version for now.

will report my findings asap, but unfortunately most probably not until
tomorrow

- thomas


----- Original Message -----
From: "Dave Page"
To:
Cc: "Hiroshi Saito" ; "Hiroshi Inoue"

Sent: Tuesday, October 24, 2006 12:59 PM
Subject: [ODBC] New release?


I'll be bundling PostgreSQL 8.2 for Windows tomorrow and want to include
an updated psqlODBC build. Please shout ASAP if there is a good reason
why I shouldn't build psqlODBC 08.02.0200 for inclusion!

Regards Dave.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly



---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: New release?

Dave Page wrote:
> I'll be bundling PostgreSQL 8.2 for Windows tomorrow and want to include
> an updated psqlODBC build. Please shout ASAP if there is a good reason
> why I shouldn't build psqlODBC 08.02.0200 for inclusion!

I've committed a bug fix about Use declare_fetch mode reported by Garner
Chung.
I've committed all the code now.

regards,
Hiroshi Inoue

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: New release?

=20

> -----Original Message-----
> From: Hiroshi Inoue [mailto:inoue@tpf.co.jp]=20
> Sent: 24 October 2006 13:11
> To: Dave Page
> Cc: pgsql-odbc@postgresql.org; Hiroshi Saito
> Subject: Re: New release?
>=20
> Dave Page wrote:
> > I'll be bundling PostgreSQL 8.2 for Windows tomorrow and=20
> want to include
> > an updated psqlODBC build. Please shout ASAP if there is a=20
> good reason
> > why I shouldn't build psqlODBC 08.02.0200 for inclusion!
>=20
> I've committed a bug fix about Use declare_fetch mode=20
> reported by Garner=20
> Chung.
> I've committed all the code now.

Great - thanks Hiroshi.

Regards, Dave

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly

Re: New release?

=20

> -----Original Message-----
> From: Thomas H. [mailto:me@alternize.com]=20
> Sent: 24 October 2006 12:12
> To: Dave Page; pgsql-odbc@postgresql.org
> Cc: Hiroshi Saito; Hiroshi Inoue
> Subject: Re: [ODBC] New release?
>=20
> i have an open issue in 8.2b1 with psqlOdbc 8.2.02 (paged=20
> recordset-query=20
> that "crashes"), but unfortunately due to more severe 8.2b1=20
> problems i=20
> wasn't yet able to gather data and report it properly. i've=20
> switched to an=20
> older driver version for now.
>=20
> will report my findings asap, but unfortunately most probably=20
> not until=20
> tomorrow

OK - please open a tracker when you have to info. I'll go ahead and
bundle anyway for now as Hiroshi has committed all his bug fixes to
date. Hopefully we can get yours before we release PostgreSQL 8.2.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Re: New release?

Dave Page wrote:
>
>
>
>> -----Original Message-----
>> From: Hiroshi Inoue [mailto:inoue@tpf.co.jp]
>> Sent: 24 October 2006 13:11
>> To: Dave Page
>> Cc: pgsql-odbc@postgresql.org; Hiroshi Saito
>> Subject: Re: New release?
>>
>> Dave Page wrote:
>>
>>> I'll be bundling PostgreSQL 8.2 for Windows tomorrow and
>>>
>> want to include
>>
>>> an updated psqlODBC build. Please shout ASAP if there is a
>>>
>> good reason
>>
>>> why I shouldn't build psqlODBC 08.02.0200 for inclusion!
>>>
>> I've committed a bug fix about Use declare_fetch mode
>> reported by Garner
>> Chung.
>> I've committed all the code now.
>>
>
> Great - thanks Hiroshi.
>

Oops I forgot to mention I've never compiled it under 64bit mode.
Could anyone compile it on 64bit *nix machine ?

regards,
Hiroshi Inoue
>


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org

Re: New release?

=20

> -----Original Message-----
> From: Hiroshi Inoue [mailto:inoue@tpf.co.jp]=20
> Sent: 24 October 2006 15:48
> To: Dave Page
> Cc: pgsql-odbc@postgresql.org; Hiroshi Saito
> Subject: Re: New release?
>=20
> Oops I forgot to mention I've never compiled it under 64bit mode.
> Could anyone compile it on 64bit *nix machine ?

Seems even 32 bit is broken on my normal build machine:

gcc -DHAVE_CONFIG_H -I. -I. -I. -O2 -Wall -Wmissing-prototypes
-Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels
-fno-strict-aliasing -I/usr/local/pgsql/include -g -O2 -MT info.lo -MD
-MP -MF .deps/info.Tpo -c info.c -fPIC -DPIC -o .libs/info.o
In file included from psqlodbc.h:490,
from info.c:19:
misc.h:127: error: syntax error before "ssize_t"
misc.h:129: error: syntax error before "ssize_t"
misc.h:130: error: syntax error before "ssize_t"
misc.h:131: error: syntax error before "ssize_t"
misc.h:132: error: syntax error before "ssize_t"
misc.h:134: error: syntax error before "ssize_t"
misc.h:136: error: syntax error before "ssize_t"
misc.h:149: error: syntax error before "my_strcpy"
misc.h:149: error: syntax error before "ssize_t"
misc.h:149: warning: type defaults to `int' in declaration of
`my_strcpy'
misc.h:149: warning: data definition has no type or storage class
info.c: In function `PGAPI_GetInfo':
info.c:827: warning: label `cleanup' defined but not used
info.c: In function `PGAPI_GetTypeInfo':
info.c:972: warning: label `cleanup' defined but not used
info.c: In function `PGAPI_Statistics':
info.c:2866: warning: unused variable `relkind'
info.c: In function `PGAPI_ColumnPrivileges':
info.c:3415: warning: label `cleanup' defined but not used
make[1]: *** [info.lo] Error 1
make[1]: Leaving directory
`/usr/local/src/postgresql-8.1.5/src/interfaces/psqlodbc'
make: *** [all] Error 2

That's on a recent Slackware linux, with gcc (GCC) 3.4.5.

:-(

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq

Re: New release?

=20

> -----Original Message-----
> From: pgsql-odbc-owner@postgresql.org=20
> [mailto:pgsql-odbc-owner@postgresql.org] On Behalf Of Dave Page
> Sent: 24 October 2006 15:51
> To: Hiroshi Inoue
> Cc: pgsql-odbc@postgresql.org; Hiroshi Saito
> Subject: Re: [ODBC] New release?
>=20
>
>=20
> > -----Original Message-----
> > From: Hiroshi Inoue [mailto:inoue@tpf.co.jp]=20
> > Sent: 24 October 2006 15:48
> > To: Dave Page
> > Cc: pgsql-odbc@postgresql.org; Hiroshi Saito
> > Subject: Re: New release?
> >=20
> > Oops I forgot to mention I've never compiled it under 64bit mode.
> > Could anyone compile it on 64bit *nix machine ?
>=20
> Seems even 32 bit is broken on my normal build machine:
>=20
> gcc -DHAVE_CONFIG_H -I. -I. -I. -O2 -Wall -Wmissing-prototypes
> -Wpointer-arith -Winline -Wdeclaration-after-statement -Wendif-labels
> -fno-strict-aliasing -I/usr/local/pgsql/include -g -O2 -MT info.lo -MD
> -MP -MF .deps/info.Tpo -c info.c -fPIC -DPIC -o .libs/info.o
> In file included from psqlodbc.h:490,
> from info.c:19:
> misc.h:127: error: syntax error before "ssize_t"
> misc.h:129: error: syntax error before "ssize_t"
> misc.h:130: error: syntax error before "ssize_t"
> misc.h:131: error: syntax error before "ssize_t"
> misc.h:132: error: syntax error before "ssize_t"
> misc.h:134: error: syntax error before "ssize_t"
> misc.h:136: error: syntax error before "ssize_t"
> misc.h:149: error: syntax error before "my_strcpy"
> misc.h:149: error: syntax error before "ssize_t"
> misc.h:149: warning: type defaults to `int' in declaration of
> `my_strcpy'
> misc.h:149: warning: data definition has no type or storage class
> info.c: In function `PGAPI_GetInfo':
> info.c:827: warning: label `cleanup' defined but not used
> info.c: In function `PGAPI_GetTypeInfo':
> info.c:972: warning: label `cleanup' defined but not used
> info.c: In function `PGAPI_Statistics':
> info.c:2866: warning: unused variable `relkind'
> info.c: In function `PGAPI_ColumnPrivileges':
> info.c:3415: warning: label `cleanup' defined but not used
> make[1]: *** [info.lo] Error 1
> make[1]: Leaving directory
> `/usr/local/src/postgresql-8.1.5/src/interfaces/psqlodbc'
> make: *** [all] Error 2
>=20
> That's on a recent Slackware linux, with gcc (GCC) 3.4.5.

And including unistd.h in mish.h seems to solve it.

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Re: New release?

Looking good here on NT4, optionally with MDAC 2.1 SP2, against v7 and v8
server. I might still have an issue with a gross slowdown when logging is
enabled, but that appears to depend on what system I'm using for testing so
might be an artifact of running NT under Linux+Qemu (however I've
restored-to-known-state so many times over the last few days I'd have been stuck
without it).

--
Mark Morgan Lloyd
markMLl .AT. telemetry.co .DOT. uk

[Opinions above are the author's, not those of his employers or colleagues]

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org