We're trying to switch to native hstore support from our older, home grown one.
There is a place where we store some configuration files / scripts as hstore values. When updating one of these values we came across a potential escaping issue where the code generated SQL that produced a SYNTAX ERROR. The basic gist of this is ... UPDATE "something" SET thing = '"file" => ".....fooo \\"something\\"...."'; causes a 'Syntax Error near 's' at position ... Simply adding an 'E" to the beginning of the value fixes things. This is with a psql 9.0 and 9.1 db and seems to make sense from what I've read about standard_conforming_strings. Thoughts? -- You received this message because you are subscribed to the Google Groups "sequel-talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/sequel-talk/-/HjxwA9nGY3QJ. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sequel-talk?hl=en.
