Re: Bug #737: PQescapeBytea parameter #3 size_t *to_length

Your patch has been added to the PostgreSQL unapplied patches list at:

http://candle.pha.pa.us/cgi-bin/pgpatches

I will try to apply it within the next 48 hours.

---------------------------------------------------------------------------

pgsql-bugs(at)postgresql(dot)org wrote:
> Christoph Haller (ch(at)rodos(dot)fzk(dot)de) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> PQescapeBytea parameter #3 size_t *to_length
>
> Long Description
> Hi,
>
> I am referring to
>
> PostgreSQL 7.2.1 Documentation
> Chapter 1. libpq - C Library
> 1.3. Command Execution Functions
> 1.3.3. Escaping binary strings for inclusion in SQL queries
>
> I found the line
> "The result string length does not include the terminating zero byte of the result."
> is not right.
> The result string length does indeed include the terminating zero byte.
>
> When I do
>
> binarystr = (char *)
> PQescapeBytea((unsigned char *)"\01\02",2,(size_t *)&binarylen);
> printf(" binarylen = %d \n", binarylen) ;
>
> I'll get
> binarylen = 3
>
> I also dropped a DocNote, but unfortunately there is no way to
> scroll on longer notes. Maybe you like to fix this, too.
>
> Regards, Christoph
>
>
> Sample Code
>
>
> No file was uploaded with this report
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073