cvs commit: ports/databases/py-pyPgSQL Makefile distinfo

[Philip M. Gollucci]

pgollucci    2010-09-10 04:18:06 UTC

  FreeBSD ports repository

  Modified files:
    databases/py-pyPgSQL Makefile distinfo 
  Log:
  PostgreSQL 8.3.1 has changed it's bytea encoding.
  
  * in PostgreSQL 8.3.1 Release note
  Make encode(bytea, 'escape') convert all high-bit-set byte values into \nnn octal escape sequences (Tom)
  
  This is necessary to avoid encoding problems when the database encoding is multi-byte. This change could pose compatibility issues for applications that are expecting specific results from encode.
  
  but pyPgSQL escape bytea encode as it's own implementments. PostgreSQL says that it may make failure(see PQescapeBytea documentation).
  
  in PQescapeBytea function documentation:
  "The only difference from PQescapeByteaConn is that PQescapeBytea does not take a PGconn parameter. Because of this, it cannot adjust its behavior depending on the connection properties (in particular, whether standard-conforming strings are enabled) and therefore it might give the wrong results. Also, it has no way to return an error message on failure."
  
  Patch is included upstream already
  
  PR:             ports/122616
  Submitted by:   "Choe, Cheng-Dae" <whitekid at gmail.com>
  
  Revision  Changes    Path
  1.20      +11 -1     ports/databases/py-pyPgSQL/Makefile
  1.10      +3 -0      ports/databases/py-pyPgSQL/distinfo