| From: | Maarten Deprez <maartendeprez(at)scarlet(dot)be> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: escaping and quoting |
| Date: | 2008-05-21 11:33:02 |
| Message-ID: | 1211369582.9759.8.camel@simbelmyne.be.eu.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Albe Laurenz wrote:
> Does the program work correctly despite the warnings?
At least it seems so. I'm using it as email server without problems.
> What API are you using (there is no EscapeBytea function in the C API)?
It's the PQescapeBytea function from libpq. Note that i didn't write the
program, so i don't know the code so well.
> Exactly how does the bytea string constant look that you send to the server?
For example (taken from the log and completed a bit):
INSERT INTO ... (..., messageblk,blocksize, physmessage_id) VALUES
(0,'SA\\304...')
> Are there any other strings with backslashes in your statements?
Don't know, probably yes. The backslashes are probably generated by the
escape function.
Greetings,
Maarten Deprez
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Sergio Borgonovo | 2008-05-21 11:48:51 | Re: Postgresql MVCC, Read Committed Isolation Level and taking "snapshot" |
| Previous Message | Thomas Kellerer | 2008-05-21 10:05:47 | XML2 module and xpath_table |