Edit report at http://bugs.php.net/bug.php?id=51608&edit=1
ID: 51608
Updated by: fel...@php.net
Reported by: cbandy at jbandy dot com
Summary: pg_copy_to: WARNING: nonstandard use of \\ in a string
literal
-Status: Open
+Status: Closed
Type: Bug
Package: PostgreSQL related
Operating System: Linux
PHP Version: 5.3.2
-Assigned To:
+Assigned To: felipe
New Comment:
This bug has been fixed in SVN.
Snapshots of the sources are packaged every three hours; this change
will be in the next snapshot. You can grab the snapshot at
http://snaps.php.net/.
Thank you for the report, and for helping us make PHP better.
Thanks for the patch.
Previous Comments:
------------------------------------------------------------------------
[2010-04-20 13:49:25] fel...@php.net
Automatic comment from SVN on behalf of felipe
Revision: http://svn.php.net/viewvc/?view=revision&revision=298210
Log: - Fixed bug #51608 (pg_copy_to: WARNING: nonstandard use of \\ in a
string literal)
Patch by: cbandy at jbandy dot com
------------------------------------------------------------------------
[2010-04-20 02:16:12] cbandy at jbandy dot com
Description:
------------
Whenever I use pg_copy_to() on PostgreSQL 8.4.2 I get a warning in
/var/lib/pgsql/data/postmaster.log:
> WARNING: nonstandard use of \\ in a string literal at character 62
> HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
This is caused by the SQL generated in pg_copy_to.
r277069 addressed this issue for pg_copy_from and should also be applied
to pg_copy_to.
Test script:
---------------
// setup
pg_query($db, 'CREATE TEMP TABLE temp_test_table (a INT)');
pg_query($db, 'INSERT INTO temp_test_table VALUES (1)');
// test
$rows = pg_copy_to($db, 'temp_test_table');
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/bug.php?id=51608&edit=1
