note 102508 added to function.pg-copy-from
[email protected] Fri, 18 Feb 2011 02:39:45 -0800
| Newsgroups | php.notes |
|---|---|
| Message-ID | <[email protected]> |
Fix for "Copy command failed: ERROR: literal carriage return
found in data" or
"Copy command failed: ERROR: missing data for column
"message" CONTEXT: COPY message, line 1:"
<?php
$message = "HEJ\rHEJ\nHEJ\r\nHEJ\n\rHEJ\tHELLO\\";
$message = addslashes($message);
$message = str_replace(
array("\n\r","\r\n","\n","\r","\t"),
array("\r","\r","\r","\\r","\\t"),
$message);
$copy_message = "1;". $message .";300";
pg_copy_from($db, "message", $copy_message, ";");
?>
----
Server IP: 69.147.83.197
Probable Submitter: 88.131.54.66
----
Manual Page -- http://www.php.net/manual/en/function.pg-copy-from.php
Edit -- https://master.php.net/note/edit/102508
Del: integrated -- https://master.php.net/note/delete/102508/integrated
Del: useless -- https://master.php.net/note/delete/102508/useless
Del: bad code -- https://master.php.net/note/delete/102508/bad+code
Del: spam -- https://master.php.net/note/delete/102508/spam
Del: non-english -- https://master.php.net/note/delete/102508/non-english
Del: in docs -- https://master.php.net/note/delete/102508/in+docs
Del: other reasons-- https://master.php.net/note/delete/102508
Reject -- https://master.php.net/note/reject/102508
Search -- https://master.php.net/manage/user-notes.php