← Back to team overview

launchpad-reviewers team mailing list archive

[Merge] ~tushar5526/launchpad:use-escape-string-syntax into launchpad:master

 

The proposal to merge ~tushar5526/launchpad:use-escape-string-syntax into launchpad:master has been updated.

Description changed to:

At the time of this commit, `standard_conforming_strings` is set to `false` in the LP database. Starting with PostgreSQL 9, the default value for this setting was set to `true`.

To enable `standard_conforming_strings` in the future, all SQL queries that rely on escape sequences must be updated to either use the `E'...'` (escape string) syntax or avoid using \. This ensures that the queries behave consistently regardless of whether the setting is `on` or `off`.

For more details, see:
https://code.launchpad.net/~tushar5526/launchpad/+git/launchpad/+merge/493109
-- 
Your team Launchpad code reviewers is requested to review the proposed merge of ~tushar5526/launchpad:use-escape-string-syntax into launchpad:master.



References