#50195 [Opn->Csd]: pg_copy_to does not allow schema in the tablename argument

ID: 50195 Updated by: iliaa@php.net Reported By: eddie at eddiemonge dot com -Status: Open +Status: Closed Bug Type: PostgreSQL related Operating System: Linux PHP Version: 5.2.11 New Comment: This bug has been fixed in SVN. Snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at http://snaps.php.net/. Thank you for the report, and for helping us make PHP better. Previous Comments: ------------------------------------------------------------------------ [2009-11-25 14:28:01] svn@php.net Automatic comment from SVN on behalf of iliaa Revision: http://svn.php.net/viewvc/?view=revision&revision=291312 Log: Fixed bug #50195 (pg_copy_to() fails when table name contains schema). ------------------------------------------------------------------------ [2009-11-16 21:37:45] eddie at eddiemonge dot com Description: ------------ When trying to use pg_copy_to on a schema other than public, the tablename argument should allow the schema to be passed in, i.e. pg_copy_to($conn, "schema.tablename"). Reproduce code: --------------- --- From manual page: function.pg-copy-to#Description --- $tablename = "mwa.newprojects"; $rows = pg_copy_to($db, $tablename); Expected result: ---------------- Return the contents of the table into a formatted array Actual result: -------------- FAILED ERROR: relation "mwa.newprojects" does not exist ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=50195&edit=1