Bug #51607 [Opn->Csd]: pg_copy_from does not allow schema in the tablename argument

From: Date: Tue, 20 Apr 2010 15:59:33 +0000
Subject: Bug #51607 [Opn->Csd]: pg_copy_from does not allow schema in the tablename argument
References: 1  Groups: php.bugs 
Request: Send a blank email to php-bugs+get-149734@lists.php.net to get a copy of this message 
Edit report at http://bugs.php.net/bug.php?id=51607&edit=1

 ID:               51607
 Updated by:       felipe@php.net
 Reported by:      cbandy at jbandy dot com
 Summary:          pg_copy_from does not allow schema in the tablename
                   argument
-Status:           Open
+Status:           Closed
 Type:             Bug
 Package:          PostgreSQL related
 Operating System: Linux
 PHP Version:      5.3.2
-Assigned To:      
+Assigned To:      felipe

 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.

Thanks for the patch.


Previous Comments:
------------------------------------------------------------------------
[2010-04-20 17:59:03] felipe@php.net

Automatic comment from SVN on behalf of felipe
Revision: http://svn.php.net/viewvc/?view=revision&revision=298223
Log: - Fixed bug #51607 (pg_copy_from does not allow schema in the
tablename argument)
  Patch by: cbandy at jbandy dot com

------------------------------------------------------------------------
[2010-04-20 01:50:10] cbandy at jbandy dot com

Description:
------------
It is not possible to include the schema when passing a table name to
pg_copy_from, e.g. pg_copy_from($conn, "schema.tablename", $rows).

r291312 addressed this issue for pg_copy_to, though the attached patch
seems simpler.

Test script:
---------------
// setup
pg_query($db, 'CREATE SCHEMA temp_test_schema');
pg_query($db, 'CREATE TABLE temp_test_schema.temp_test_table (a INT)');

// test
pg_copy_from($db, 'temp_test_schema.temp_test_table', array('1'));

// cleanup
pg_query($db, 'DROP SCHEMA temp_test_schema CASCADE');

Expected result:
----------------
The row is copied without error

Actual result:
--------------
pg_copy_from() : Copy command failed: ERROR: relation
"temp_test_schema.temp_test_table" does not exist


------------------------------------------------------------------------



-- 
Edit this bug report at http://bugs.php.net/bug.php?id=51607&edit=1

Thread (2 messages)

« previous php.bugs (#149734) next »