Re: PgSQL query warning

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--===============0608431122365084158==
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="------------enig5EF864534A7B7EAB14EFAB21"

This is an OpenPGP/MIME signed message (RFC 2440 and 3156)
--------------enig5EF864534A7B7EAB14EFAB21
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On 06/12/2013 11:56 AM, Chris Moules wrote:
> During some recent testing I was getting:
> 'WARNING:  nonstandard use of \\ in a string literal'
> 'HINT:  Use the escape string syntax for backslashes, e.g., E'\\'.'
>=20
> I believe the query in question was not updated since PgSQL 7 times.
>=20
> Patch attached, not heavily tested as I do not use PgSQL in production.=

> Maybe a dspam & PgQSL expert can check this. If PgSQL is constantly
> issuing warnings, I can imagine that it slows it down a fraction.
>=20

Hi Chris,

This is already fixed some time ago, I think it was this commit [1].
What version of dspam are you running, and which version of postgresql
server?

[1]
http://dspam.git.sourceforge.net/git/gitweb.cgi?p=3Ddspam/dspam;a=3Dcommi=
tdiff;h=3D9bc231ae79f84a973ced531356833142c4ae2766

--
Regards,
	Tom



--------------enig5EF864534A7B7EAB14EFAB21
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with undefined - http://www.enigmail.net/

iQIcBAEBAgAGBQJRuFMQAAoJEJPfMZ19VO/1v+UP/RY/G3apreSNxdezr0srZrWu
YWrVH+QkJwTUooQCzOkwkz4VvOmrzKcoukp747eOeFPeoIAoGmzfCSzrCVVKD4Xr
y/LvOJC8Vb/rSR7sboYtbDOVI2WqIpAwWprDu3H4/ShKwDnX68eJGOxTEkONRY6L
SEgsyM86D+sOZf+49P07ixtugK4s6XAb1vpX9qURNR5l1gz/epiYWhsfZGMkPM2e
0d0SX8/KgtB/QDe50oz/iePwzcLk1OlAIoukvcx0/v8oLwXQh76Vf7OorWwJRHb8
KImyE3hivn+RWF88Qh8FsgPYPGRttSX80ChKJ9PgidqdV6mWG2RQy6xBuKylEwxg
yNcWKeMit7qWD3POUVSOFVao1MnnpOaj7D2vyadvhMPcvAc/qxvuhBlROeeI0ucE
g3P8S6m+Z9svigG/lYDFIl0MnrNnx60seibu+aTdiZLgilvOm05agnJQ45d4/AGj
Zjs9syFP6Glb5suLgsTN5dk12U0aMvURGI7EMe9HVT4W08eIWhPV1t9TdUPYHods
N6m9CHXKE6S5uKj19c6qfVj/ARFxpUPw2qq5S7uWkU6rlxYBcjlrvCzOttjcXBxf
zN2uwpoZhB4Bk4RAenb/ZQlyv+LKS7U5Z4dOM9rQmicBesJxAGgMjLrPSQqKmNgd
e7Go1FiLvww5I1yT+739
=LbZB
-----END PGP SIGNATURE-----

--------------enig5EF864534A7B7EAB14EFAB21--


--===============0608431122365084158==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

------------------------------------------------------------------------------
This SF.net email is sponsored by Windows:

Build for Windows Store.

http://p.sf.net/sfu/windows-dev2dev
--===============0608431122365084158==
Content-Type: text/plain; charset="us-ascii"
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

_______________________________________________
Dspam-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspam-devel

--===============0608431122365084158==--