Re: 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>_
> <mailto:h-inoue(at)dream(dot)email(dot)ne(dot)jp>
> Cc: _pgsql-odbc(at)postgresql(dot)org_ <mailto: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