> > >>Yes, I really don't understand either !
> > >>But even though all use libpq.dll, they might not handle the data
> > >>the same way. Mayboe ODBC needs to check for data type, field
> > >>length, etc... and the other frontends do not need this kind of
> > >>information ?
> > >
> > >Hm. That's an interesting observation. When you do a query
> with ODBC,
> > >does it do any "extra queries" automatically on the system tables?
> > >Enable statement logging on the server and see if
> something weird shows up.
> >
> > No, no query on the system tables.
> > I am not very familiar with the log though, maybe Ludek
> could tell us
> > more about that ?
>
> If I remember it right we measure the time problem in
> LIBPQ_send_query function in connection.c (I'm not sure with
> filename).
> Magnus, could you take a look at the code? Maybe you find the problem.
> I'm sorry I have no time for it today.
> BTW we change the code between 08.01.0102 and 08.01.0200 from
> PQexec to PQsendquery and PQgetresult (I write this from my
> head so it could be little different names). But I think
> Arnaud has problem even with 08.01.0102.

That's very interestnig information. Because that was one thing that was
different.

Arnaud, any chance you can giev it a try with 8.01.0200?

//Magnus

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

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

> > If I remember it right we measure the time problem in
> > LIBPQ_send_query function in connection.c (I'm not sure with
> > filename).
> > Magnus, could you take a look at the code? Maybe you find the problem.
> > I'm sorry I have no time for it today.
> > BTW we change the code between 08.01.0102 and 08.01.0200 from
> > PQexec to PQsendquery and PQgetresult (I write this from my
> > head so it could be little different names). But I think
> > Arnaud has problem even with 08.01.0102.
>
> That's very interestnig information. Because that was one thing that was
> different.
>
> Arnaud, any chance you can giev it a try with 8.01.0200?

Please try both, 08.01.0102 and 08.01.0200. Does it differ?

Thanks,

Luf

---------------------------(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

Ludek Finstrle a écrit :
>> That's very interestnig information. Because that was one thing that was
>> different.
>>
>> Arnaud, any chance you can giev it a try with 8.01.0200?
>
> Please try both, 08.01.0102 and 08.01.0200. Does it differ?

I just tried both versions and there is absolutely no difference.

I'll stick with .0200 of course !

Regards
--
Arnaud


---------------------------(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