To make it clear,the right fix is it to replace the \ with ': mother\'s day -> mother''s day

I am confused. The only reason for that Postgeres option is those line that can be fixed with a simple correction, why wiki tells us to turn off the option? We could simply fix the Postgeres installation file.

Given that we are talking about SMF 2.0.x, if it works, I'd say go for it.

This option is there to assist users working with MySQL-oriented DBs. And SMF 2.0.x is a MySQL-oriented DB.

The problem is that MySQL does a lot of non-standard stuff, that is not ANSI-compliant. Postgresql tries to be (a) ANSI-compliant, and (b) still allow folks to work with that non-standard MySQL stuff. Hence options like this.

I am working under the assumption this won't be the only time you run into this problem, e.g., with mods or other elements of code in 2.0.x. I doubt the installer is the only place you will have issues. Hence, I'd suggest turning it off.

Going forward, with 2.1, SMF is moving towards ANSI-compliance, which means that Postgresql will be better supported. MySQL itself is slowly attempting to move in that direction.

Logged

Address the process rather than the outcome. Then, the outcome becomes more likely. - Fripp