* Tom Lane: > Florian Weimer <fweimer@xxxxxx> writes: >> Put differently, I think it's rather odd that in 9.0, both >> encode(bytea_value, 'escape') and encode(bytea_value, 'hex') output >> hexadecimal values. > > I don't believe that; encode produces text not bytea, so its result > is not affected by this setting. And you are right, as usual. It turns out that we've got a double-encoding issue in the loader. How embarrassing. -- Florian Weimer <fweimer@xxxxxx> BFK edv-consulting GmbH http://www.bfk.de/ Kriegsstraße 100 tel: +49-721-96201-1 D-76133 Karlsruhe fax: +49-721-96201-99 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general