From: Ivan Kohler <ivan@freeside.biz>
Date: Mon, 24 Jul 2017 20:38:11 +0000 (-0700)
Subject: PG_BYTEA seems to be working nowadays, and uses much less memory than our alternative... 
X-Git-Url: http://git.freeside.biz/gitweb/?p=freeside.git;a=commitdiff_plain;h=994b2be1b9b039d309a9527ac598a16cbb7e80e9

PG_BYTEA seems to be working nowadays, and uses much less memory than our alternative, RT#76731
---

diff --git a/FS/FS/Record.pm b/FS/FS/Record.pm
index 7e486905d..f2e9e6fba 100644
--- a/FS/FS/Record.pm
+++ b/FS/FS/Record.pm
@@ -3554,11 +3554,7 @@ sub _quote {
            && driver_name eq 'Pg'
           )
   {
-    no strict 'subs';
-#    dbh->quote($value, { pg_type => PG_BYTEA() }); # doesn't work right
-    # Pg binary string quoting: convert each character to 3-digit octal prefixed with \\, 
-    # single-quote the whole mess, and put an "E" in front.
-    return ("E'" . join('', map { sprintf('\\\\%03o', ord($_)) } split(//, $value) ) . "'");
+    dbh->quote($value, { pg_type => PG_BYTEA() });
   } else {
     dbh->quote($value);
   }