|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2005-06-26 19:18 UTC] sniper@php.net
[2005-06-27 08:22 UTC] joey@php.net
[2005-06-27 08:43 UTC] joey@php.net
|
|||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Sun Nov 02 03:00:01 2025 UTC |
Description: ------------ There seems to be a confusion in handling stdin between PostgreSQL and PHP. Reproduce code: --------------- <?php $conn = pg_connect("user=knt dbname=template1") or die("Connection failed!\n"); print "Starting query...\n"; $res = pg_query("COPY example_table FROM stdin"); /* * If I'd not use a pg_end_copy() call just after "COPY FROM * stdin" query, script flow will never pass through this * line and stuck here with a 100% CPU usage. */ if ( pg_result_status($res) != PGSQL_COPY_IN ) die("Unexpected result status!\n"); print "At last!\n"; pg_close(); ?> /* * The same of this script * [http://yazicivo.fateback.com/example-copy.txt] written * in C (with same libpq calls) works fine. */ Expected result: ---------------- shell$ php example-copy.php Starting query... At last! shell$ _ Actual result: -------------- shell$ php example-copy.php Starting query... # It enters to an endless loop with a 100% CPU usage.