Re: BUG #8524: PQsendQueryParams with RETURNING clause on a INSERT

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: peter(dot)reijnders(at)verpeteren(dot)nl
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #8524: PQsendQueryParams with RETURNING clause on a INSERT
Date: 2013-11-11 03:21:18
Message-ID: 22390.1384140078@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

peter(dot)reijnders(at)verpeteren(dot)nl writes:
> I am having troubles with a the RETURNING clause on a INSERT when using
> PQsendQueryParams.

The bug in this test program is that you're asking for binary output
format (by passing 1 as the last argument to PQsendQueryParams) but then
expecting text-format results. The one column that's of type text prints
okay anyway (since there's no difference), but the others don't. If
you change that argument to zero, the program prints the expected results.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message mle+tools 2013-11-11 03:44:43 BUG #8586: Misleading fe_sendauth error message
Previous Message Tom Lane 2013-11-11 01:57:15 Re: BUG #8532: postgres fails to start with timezone-data >=2013e