Join GitHub today
GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.Sign up
[dev.icinga.com #1974] change standard string escaping for postgresql queries to use the E'foo' notation #754
This issue has been migrated from Redmine: https://dev.icinga.com/issues/1974
Created by mfriedrich on 2011-10-03 07:25:45 +00:00
this can be done otherwise, but needs further investigation how this works out with libdbi.
2012-02-18 17:23:41 +00:00 by mfriedrich 62344c3
2012-04-28 09:14:04 +00:00 by mfriedrich 6332556
Updated by mfriedrich on 2011-11-09 08:55:18 +00:00
with postgresql 9.x this will be an error and therefore a significant bug to be resolved. question remains, if it's worth patching libdbi (needs a full rewrite on query creation), or focus on libpq and add parameter bindings to all postgresql queries removing necessary escaping.
Updated by mfriedrich on 2012-02-18 17:17:44 +00:00
a final query looks like this
Updated by mfriedrich on 2012-02-18 18:14:14 +00:00
=> reschedule a new check to trigger the output to be inserted into the db
without patch, postgresql 9.1 log
empty logs, data fully within database.