BUG #4843: non standard use string literal warning in RAISE WARNING - Mailing list pgsql-bugs

From Regina
Subject BUG #4843: non standard use string literal warning in RAISE WARNING
Date
Msg-id 200906080448.n584mwTk023104@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #4843: non standard use string literal warning in RAISE WARNING
List pgsql-bugs
The following bug has been logged online:

Bug reference:      4843
Logged by:          Regina
Email address:      lr@pcorp.us
PostgreSQL version: 8.4beta2
Operating system:   Windows
Description:        non standard use string literal warning in RAISE WARNING
Details:

I'm not sure if this is a bug or expected behavior.  But in a new PostGIS
function we are writing, we are getting a

WARNING: nonstandard use of \' in a string literal HINT: Use  to write
quotes in strings, or use the escape string syntax (E'...').

With sections of the code that look like
RAISE WARNING 'Not inserting \'%\' in \'%.%\' into geometry_columns: could
not determine ndims', quote_ident(gcs.attname), quote_ident(gcs.nspname),
quote_ident(gcs.relname);


The same function on 8.3.7 does not do this.  I verified I have the
escape_string_warning switch enabled on both installs.


Details of the issue can be found here

http://trac.osgeo.org/postgis/ticket/190#comment:4

pgsql-bugs by date:

Previous
From: Dave Page
Date:
Subject: Re: BUG #4842: Doesn't install
Next
From: Tom Lane
Date:
Subject: Re: BUG #4843: non standard use string literal warning in RAISE WARNING