Hi trac developers :)

we have just wasted a day of our deploy manager time :)

so I decided to let you know, that trac is broken under following
conditions:

- using postgresql 8.2 or later with configuration setting
standard_conforming_strings = on

symptoms:

'\r\n' inside wiki text, and all multiline text inside database...


solution:  do NOt use standard_conforming_strings, OR use some other
(SQL standards conformant) method of inserting newlines with SQL

preferred method would be to use E'string' escape syntax

links:
http://www.postgresql.org/docs/8.3/static/sql-syntax-lexical.html#SQL-SYNTAX-CONSTANTS
http://www.postgresql.org/docs/8.3/static/runtime-config-compatible.html



cheers!

Filip Rembiałkowski
eo Networks
Warsaw, Poland

--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Trac 
Development" group.
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/trac-dev?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to