Thread: Bug #737: PQescapeBytea parameter #3 size_t *to_length
Christoph Haller (ch@rodos.fzk.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
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@postgresql.org wrote: > Christoph Haller (ch@rodos.fzk.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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073
Doc change made. Thanks. --------------------------------------------------------------------------- pgsql-bugs@postgresql.org wrote: > Christoph Haller (ch@rodos.fzk.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@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073