php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #63657 pgsqlCopyFromFile, pgsqlCopyToArray use Postgres < 7.3 syntax
Submitted: 2012-11-30 12:28 UTC Modified: 2013-06-07 07:19 UTC
From: [email protected] Assigned: mbeccati (profile)
Status: Closed Package: PDO related
PHP Version: 5.4.9 OS:
Private report: No CVE-ID: None
View Developer Edit
 [2012-11-30 12:28 UTC] [email protected] 
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 commitsRelated reports
 [2013-06-04 23:57 UTC] [email protected]
-Assigned To: +Assigned To: mbeccati
 [2013-06-07 07:19 UTC] [email protected]
-Summary: pgsqlCopyFromFile, pgsqlCopyToArray have syntax errors +Summary: pgsqlCopyFromFile, pgsqlCopyToArray use Postgres < 7.3 syntax
 [2013-06-07 07:19 UTC] [email protected] 
That's simply not true. If you were receiving an error, it must have been something else. See:

http://www.postgresql.org/docs/9.2/static/sql-copy.html#AEN66829

At some point compatibility with <7.3 syntax might be dropped though, so I'm going to follow the suggestion anyway (using pre-9.0 syntax).
 [2013-06-07 07:41 UTC] [email protected] 
Automatic comment on behalf of mbeccati
Revision: http://git.php.net/?p=php-src.git;a=commit;h=19ead23e8ec1e09bce080139a92d372ff1a8416b
Log: Fixed bug #63657 (pgsqlCopyFrom/To methods use Postgres &lt; 7.3 syntax)
 [2013-06-07 07:41 UTC] [email protected]
-Status: Assigned +Status: Closed
 [2013-11-17 09:30 UTC] [email protected] 
Automatic comment on behalf of mbeccati
Revision: http://git.php.net/?p=php-src.git;a=commit;h=19ead23e8ec1e09bce080139a92d372ff1a8416b
Log: Fixed bug #63657 (pgsqlCopyFrom/To methods use Postgres &lt; 7.3 syntax)
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Tue Jun 03 04:01:26 2025 UTC