Hi all,
Regarding standard_conforming_strings, I am currently reading through
the code and looking at all places that need to understand string
escaping rules.
I have found two issues where I need more advice:
arrays (org.postgresql.jdbc2.AbstractJdbc2Array)
bytea (org.postgresql.util.PGbytea)
As far as I understand, quoting in arrays and bytea only changes as far
as the types are passing through the backend parser as string-literals.
Correct?
Since the result of AbstractJdbc2Array.toString() and
PGbytea.toPGString() will be fed to PreparedStatement.setString() in the
end, we do not have to change the array or bytea code. Is this reasoning
valid?
Best Regards,
Michael Paesold