PostgreSQL 9.1 compatibility for string escaping

Discuss general development subjects that are not specific to a particular version like the versioning control system we use or other infrastructure.
Post Reply
Oleg
Posts: 1150
Joined: Tue Feb 23, 2010 2:38 am
Contact:

PostgreSQL 9.1 compatibility for string escaping

Post by Oleg »

http://www.postgresql.org/docs/9.1/stat ... #AEN106820
By default, backslashes are now ordinary characters in string literals, not escape characters. This change removes a long-standing incompatibility with the SQL standard. escape_string_warning has produced warnings about this usage for years. E'' strings are the proper way to embed backslash escapes in strings and are unaffected by this change.
Were we getting this warning?

Oleg
Posts: 1150
Joined: Tue Feb 23, 2010 2:38 am
Contact:

Re: PostgreSQL 9.1 compatibility for string escaping

Post by Oleg »

On deeper inspection this seems to only apply to "special" escape sequences like \a which we should not be using. The thing to check would be \n in strings I would think.

Post Reply