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
