I am using COPY for PostgreSQL and having problems now that the incoming
file contains more than approx 1500 lines. Is this an issue anyone is
aware of? Lot's of files over 1000 lines have worked fine, but after
getting a file over 1800 I began having problems. I have broke the file
down to a approx. 1500 line that works sometimes and not others. Here is
a snippet of what I'm trying to do:
$result = pg_exec($dbh, "COPY tblxrf FROM stdin USING DELIMITERS
','");
fseek($temp_fh,0); // go to beginning of temp file
while (($csv_line = fgets($temp_fh,1024))) {
pg_put_line($dbh, $csv_line);
}
$stat = pg_put_line($dbh, "\\.\n"); // notify db finished or report
error
if (!$stat) { echo "ERROR: An error has occurred while putting last
line of copy data<br>\n"; exit; }
$stat = pg_end_copy($dbh); // post (sync data) or report error
The process just hangs with the large number of lines, I have to kill
the COPY process for postgresql on the server before trying again.
--
Robert
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
