Re: escaping and quoting

Maarten Deprez wrote:
>>> My dbmail server using postgresql produces a lot of warnings about '\\'
>>> in strings. The particular string it is complaining about is escaped by
>>> EscapeBytea, and included in single quotes (not E''). Is it all right to
>>> set standard_compliant_strings to on?
>>
>> Depends.
>
> Okay, what do you need to know? It can be any string, a part of an email
> message. Should strings escaped by EscapeBytea be included in "''", or
> "E''" in the SQL command, to avoid the warning?

Does the program work correctly despite the warnings?
What API are you using (there is no EscapeBytea function in the C API)?
Exactly how does the bytea string constant look that you send to the server?
Are there any other strings with backslashes in your statements?
If yes, what do they look like?

Yours,
Laurenz Albe