summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorIvan Kohler <ivan@freeside.biz>2017-07-24 13:38:14 -0700
committerIvan Kohler <ivan@freeside.biz>2017-07-24 13:38:14 -0700
commit2e9cc46750e02ecf9dfabe04283d98d8afa86c26 (patch)
tree0b72b57d4f089c49651e0964f89200e5cab24925
parent91c7741223e84c67b64693cf4bbab6cfbd944e7e (diff)
PG_BYTEA seems to be working nowadays, and uses much less memory than our alternative, RT#76731
-rw-r--r--FS/FS/Record.pm6
1 files changed, 1 insertions, 5 deletions
diff --git a/FS/FS/Record.pm b/FS/FS/Record.pm
index c98de0a94..c05dac00b 100644
--- a/FS/FS/Record.pm
+++ b/FS/FS/Record.pm
@@ -3342,11 +3342,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);
}