diff options
| author | Ilia Alshanetsky <iliaa@php.net> | 2005-07-07 13:35:39 +0000 |
|---|---|---|
| committer | Ilia Alshanetsky <iliaa@php.net> | 2005-07-07 13:35:39 +0000 |
| commit | 6c332449f926ff3bc3f4bf3bb7786bcc27afcc3a (patch) | |
| tree | 65d1430b1093b0aae9141e1af20d385ad89c962c /ext/pdo_pgsql/pgsql_driver.c | |
| parent | 09d433a3491c45f25c6cbfb16b45053e078dd9fa (diff) | |
| download | php-git-6c332449f926ff3bc3f4bf3bb7786bcc27afcc3a.tar.gz | |
Use PQexecParams() when available, use original case in all other instances.
Diffstat (limited to 'ext/pdo_pgsql/pgsql_driver.c')
| -rw-r--r-- | ext/pdo_pgsql/pgsql_driver.c | 16 |
1 files changed, 13 insertions, 3 deletions
diff --git a/ext/pdo_pgsql/pgsql_driver.c b/ext/pdo_pgsql/pgsql_driver.c index 5dde6f2511..bc33bdb733 100644 --- a/ext/pdo_pgsql/pgsql_driver.c +++ b/ext/pdo_pgsql/pgsql_driver.c @@ -210,12 +210,22 @@ static char *pdo_pgsql_last_insert_id(pdo_dbh_t *dbh, const char *name, unsigned *len = spprintf(&id, 0, "%ld", (long) H->pgoid); } else { PGresult *res; - char *q; ExecStatusType status; - - spprintf(&q, sizeof("SELECT CURRVAL('')") + strlen(name), "SELECT CURRVAL('%s')", name); +#ifdef HAVE_PQEXECPARAMS + const char *q[1]; + q[0] = name; + res = PQexecParams(H->server, "SELECT CURRVAL($1)", 1, NULL, q, NULL, NULL, 0); +#else + char *name_escaped, *q; + size_t l = strlen(name); + + name_escaped = safe_emalloc(l, 2, 1); + PQescapeString(name_escaped, name, l); + spprintf(&q, 0, "SELECT CURRVAL('%s')", name_escaped); res = PQexec(H->server, q); + efree(name_escaped); efree(q); +#endif status = PQresultStatus(res); if (res && (status == PGRES_TUPLES_OK)) { |