pgsqlCopyFromFile, pgsqlCopyToArray use Postgres < 7.3 syntax
| Bug #63657 | pgsqlCopyFromFile, pgsqlCopyToArray use Postgres < 7.3 syntax | ||||
|---|---|---|---|---|---|
| Submitted: | 2012-11-30 12:28 UTC | Modified: | 2013-06-07 07:19 UTC | ||
| From: | ch@php.net | Assigned: | mbeccati (profile) | ||
| Status: | Closed | Package: | PDO related | ||
| PHP Version: | 5.4.9 | OS: | |||
| Private report: | No | CVE-ID: | None | ||
[2012-11-30 12:28 UTC] ch@php.net
Description: ------------ In ext/pdo_pgsql/pgsql_driver.c the methods pgsqlCopyToArray, pgsqlCopyFromArray etc. all use the following syntax: COPY %s FROM STDIN DELIMITERS E'%c' WITH NULL AS E'%s' In at least PostgreSQL 9.2 this is a syntax error though. The correct syntax is: COPY %s FROM STDIN WITH DELIMITER E'%c', NULL AS E'%s' a) the "WITH" is optional but must come immediately after the STDIN if given b) it's a singular "DELIMITER", not plural (btw, these method are undocumented anyway, see my other bug report about that)
Patches
Pull Requests
History
AllCommentsChangesGit/SVN commits
[2013-06-07 07:19 UTC] mbeccati@php.net
-Summary: pgsqlCopyFromFile, pgsqlCopyToArray have syntax errors +Summary: pgsqlCopyFromFile, pgsqlCopyToArray use Postgres < 7.3 syntax