diff options
author | Tom Lane <tgl@sss.pgh.pa.us> | 2009-08-04 21:56:09 +0000 |
---|---|---|
committer | Tom Lane <tgl@sss.pgh.pa.us> | 2009-08-04 21:56:09 +0000 |
commit | b1732111f233bbb72788e92a627242ec28a85631 (patch) | |
tree | 6eee199fa7bbf3d029ed9aa303f52c55313d5b54 /src/backend/executor/nodeRecursiveunion.c | |
parent | 50d08346f39b58e5cd5ff5e136065251627ff293 (diff) | |
download | postgresql-b1732111f233bbb72788e92a627242ec28a85631.tar.gz postgresql-b1732111f233bbb72788e92a627242ec28a85631.zip |
Fix pg_dump to do the right thing when escaping the contents of large objects.
The previous implementation got it right in most cases but failed in one:
if you pg_dump into an archive with standard_conforming_strings enabled, then
pg_restore to a script file (not directly to a database), the script will set
standard_conforming_strings = on but then emit large object data as
nonstandardly-escaped strings.
At the moment the code is made to emit hex-format bytea strings when dumping
to a script file. We might want to change to old-style escaping for backwards
compatibility, but that would be slower and bulkier. If we do, it's just a
matter of reimplementing appendByteaLiteral().
This has been broken for a long time, but given the lack of field complaints
I'm not going to worry about back-patching.
Diffstat (limited to 'src/backend/executor/nodeRecursiveunion.c')
0 files changed, 0 insertions, 0 deletions