Fix compatibility with PostgreSQL 9.x: bytea output.

PiotrSikora · PiotrSikora · commit c7d6a04e4ba9 · 2011-11-10T14:42:27.000Z
The issue that hit many (most?) of PostgreSQL adapters is that libpq-8.x
is unable to unescape bytea data from results in text format received
from PostgreSQL-9.x.

But we're always passing bytea data as is to the client (either from
results in binary format when using "postgres_output binary_value"
or escaped from results in text format), so this isn't problem for us.

Patch from Yichun Zhang (agentzh).
diff --git a/TODO.md b/TODO.md
@@ -1,8 +1,5 @@
 Features that sooner or later will be added to `ngx_postgres`:
 
-* Make sure that we work-around `bytea` data corruption that takes place
-  when using 9.0+ database with older client library or vice-versa.
-
 * Add support for SSL connections to the database.
 
 * Add support for dropping of idle keep-alived connections to the
diff --git a/t/output.t b/t/output.t
@@ -292,8 +292,8 @@ GET /postgres
 --- error_code: 200
 --- response_headers
 Content-Type: text/plain
---- response_body chomp
-\001
+--- response_body_like chomp
+^(?:\\001|\\x01)$
 --- timeout: 10
 
 
