From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
---|---|
To: | PostgreSQL-development Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | PQescapeBytea* version for parameters |
Date: | 2007-07-04 15:30:21 |
Message-ID: | 87fy44chki.fsf@oxford.xeocode.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Currently libpq provides a function to escape byteas to include directly in
the query string. But if you're using PQexecParam you still need to do one
layer of quoting but don't need to double the backslashes which PQescapeBytea
does if you have standard_conforming_strings set off.
Do we want something like this which provides a PQescapeByteaParam for
escaping bytea strings before passing them as text-mode parameters in
PQexecParam?
I cheated here and just passed true to standard_conforming_strings which
happens to do what we want. It might be better to provide an additional
parameter to PQescapeByteaInternal which tells it to only escape \ and NUL and
not other binary characters and '.
I didn't document it yet, I'll do that if people agree we want it.
Attachment | Content-Type | Size |
---|---|---|
PQescapeByteaParam.patch | text/x-diff | 2.7 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Darcy Buskermolen | 2007-07-04 15:32:43 | Re: Why so many out-of-disk-space failures on buildfarm machines? |
Previous Message | Zdenek Kotala | 2007-07-04 15:04:27 | script binaries renaming |