note 102508 added to function.pg-copy-from

From: Date: Fri, 18 Feb 2011 10:39:45 +0000
Subject: note 102508 added to function.pg-copy-from
Groups: php.notes 
Request: Send a blank email to php-notes+get-177101@lists.php.net to get a copy of this message
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

« previous php.notes (#177101) next »