Launchpad should run with standard_conforming_strings=on in postgresql.conf

[Stuart Bishop]

We will have trouble with future PostgreSQL upgrades if we continue to send non-SQL standard escaped strings. Most of this should be fixed by upgrading to psycopg2.

[Robert Collins (lifeless)]

Where are we at on this?

[Stuart Bishop (stub)]

I was going to do this as part of the pg 9 migration, but there is quite a bit of fallout. We will deal with standard_confirming_strings separately, so any fallout from pg 9 or standard_confirming_strings is correctly attributed.

There are two major areas I've seen where we expect plain quoted strings to accept backslash quoting:
 - regular expressions
 - accidental binary -> text casting. In particular, byte strings passed to Storm are sent as binary and at some point this is being reassembled to text. We should be passing Unicode, but we don't notice.

[Launchpad QA Bot (lpqabot)]

r17381 in stable (http://bazaar.launchpad.net/~launchpad-pqm/launchpad/stable/revision/17381) is part of this bug's fix.