Ken Johanson wrote:
Greetings,
Does anyone know if it will be possible to run the server with ANSI/ISO
string escaping instead of C-style escapes? The C style escaping is a
shoot-down for our adoption of postgres, since its non-standard.
Not yet, but we have a TODO item:
* Allow backslash handling in quoted strings to be disabled for
portability
The use of C-style backslashes (.e.g. \n, \r) in quoted strings is not
SQL-spec compliant, so allow such handling to be disabled.
Uh, what is ANSI/ISO escaping actually? I assume you mean only
supporting '' for literal quotes rather than \' too.
Yes Sir. Being able to disable the backslash-escaping is the desired
operation. In circles of business deciding wether to move to opensource
databases this is the silently used excuse (by the critics) to dismiss
pg since its arguably so fundamental and somewhat dangerous (data
loss). Getting pg to behave 'normally' would silence this excuse.