Re: Postgre driver(9.06.04.00) connected to Amazon redshift, is returning wrong count in SQLRowCount

Hi Hiroshi Inoue,

Can you please help me understand where can I find Mylog output for my
test.
I could not go to office today as I am still not quite well. I will check
with my team member tomorrow about how the old driver worked for him.

Thanks & Regards
Asif G. Shaikh

From: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
To: Asif Shaikh <asif(dot)shaikh(at)in(dot)ibm(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Date: 08/18/2017 07:54 PM
Subject: Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon
redshift, is returning wrong count in SQLRowCount

On 2017/08/18 22:47, Asif Shaikh wrote:
Hi Hiroshi Inoue,

Thanks for the reply and I am sorry for replying late on this.
Actually I was on a sick leave today.

Your statement :-
I see the result * SQLRowCount=2 * here.
--> Yes, this looks to be correct count. In my case, the variable rowc
doesn't get any value and still holds the initial value which is -1 in
your test program.

One of my team member informed me that he tried the 8.02.05 driver with
our application on RHEL and that actually worked whereas the driver
9.06.04 didn't work on the same setup.
So based on what I understood from his that the driver 9.06.04 is not
working for him whereas the old driver 8.02.05 works.
Unfortunately, I could not get all the details on this. I will get all the
details on this on Monday and will get back to you.

Meanwhile, is it possible for you to test your sample program with driver
9.06.04 to connect to Amazon redshift db and see if that reproduces the
issue for you too?

Could take Mylog output of your test and send it to me directly?

regards,
Hiroshi Inoue

Thanks & Regards
Asif G. Shaikh

From: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
To: Asif Shaikh <asif(dot)shaikh(at)in(dot)ibm(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Date: 08/17/2017 06:53 PM
Subject: Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon
redshift, is returning wrong count in SQLRowCount

On 2017/08/17 21:30, Asif Shaikh wrote:
I just built your code on 32 bit and used the 32 bit postgre
driver(8.02.05) but still it gave me same issue. :-(
When you tried, did you connect to Amazon redshift using the postgre
driver?

I see the result * SQLRowCount=2 * here.
Isn't it an expected result?

Anyway I am testing with my local server
The server's response to the command *select .. into .. from ..* is
*SELECT 2*.
If the response of Amazon redshift is different, the driver does nothing.

regards,
Hiroshi Inoue

From: Asif Shaikh/India/IBM
To: "Inoue, Hiroshi" <h-inoue(at)dream(dot)email(dot)ne(dot)jp>
Cc: pgsql-odbc(at)postgresql(dot)org
Date: 08/17/2017 05:48 PM
Subject: Re: [ODBC] Postgre driver(9.06.04.00) connected to Amazon
redshift, is returning wrong count in SQLRowCount

Hi Hiroshi Inoue,

I see the same error with the code you sent.
Did you build your application for 64 bit and used 64 bit postgre
driver(9.06.04.00) ?

Thanks & Regards
Asif G. Shaikh