Bug #63657 [NEW]: pgsqlCopyFromFile, pgsqlCopyToArray have syntax errors

From: ch Operating system: PHP version: 5.4.9 Package: PDO related Bug Type: Bug Bug description:pgsqlCopyFromFile, pgsqlCopyToArray have syntax errors 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) -- Edit bug report at https://bugs.php.net/bug.php?id=63657&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=63657&r=trysnapshot54 Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=63657&r=trysnapshot53 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=63657&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=63657&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=63657&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=63657&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=63657&r=needscript Try newer version: https://bugs.php.net/fix.php?id=63657&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=63657&r=support Expected behavior: https://bugs.php.net/fix.php?id=63657&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=63657&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=63657&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=63657&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=63657&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=63657&r=dst IIS Stability: https://bugs.php.net/fix.php?id=63657&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=63657&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=63657&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=63657&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=63657&r=mysqlcfg