Details
-
Fix
-
Status: Released (View Workflow)
-
Minor
-
Resolution: Fixed
-
None
Description
General
- Since Postgres Version 9.1 the parameter standard_conforming_strings is turn on.
- This controls whether ordinary string literals ('...') treat backslashes literally, as specified in the SQL standard. The JobScheduler may check this parameter to determine how string literals will be processed. The presence of this parameter can also be taken as an indication that the escape string syntax (E'...') is supported. Escape string syntax should be used if the JobScheduler desires backslashes to be treated as escape characters.
- See also http://www.depesz.com/index.php/2010/07/21/waiting-for-9-1-standard_conforming_strings-on/
Current Situation
- The JobScheduler has a special implementation to escape strings for Postgres because Postgres < 9.1 has a non SQL standard default behavior.
- This default behavior in Postgres has change with version 9.1. so that it is necessary to set the Postgres system variable standard_conforming_strings=off
see https://kb.sos-berlin.com/x/BYM3
Desired behavior
- The JobScheduler use for Postgres the SQL standard escaping.
Note
- All users which use the JobScheduler since above "fix version" with Postgres has to (re)set the Postgres system variable standard_conforming_strings=on.
- use show standard_conforming_strings; to check the setting.