ID: 24679 Updated by: [EMAIL PROTECTED] Reported By: rorezende at hotmail dot com -Status: Open +Status: Feedback Bug Type: PostgreSQL related -Operating System: ALL +Operating System: * PHP Version: 4.3.2 New Comment:
Please provide an example script which shows the problem clearly. Previous Comments: ------------------------------------------------------------------------ [2003-07-16 09:44:50] rorezende at hotmail dot com Description: ------------ In source code of php 4.3.2 exists an error ext/pgsql/pgsql.c. In the function pg_convert (php_pgsql_convert) it is not necessary to specify the schema name. But in the sql statement insert it is. Below is the portion of the source code which needs to be fixed. Reproduce code: --------------- ext/pgsql/pgsql.c : function : PHPAPI int php_pgsql_insert(PGconn *pg_link, const char *table, zval *var_array, ulong opt, char **sql TSRMLS_DC) line (HERE --> smart_str_appends(&querystr, table);) Must be something like : NEW HERE --> smart_str_appends(&querystr, schema); smart_str_appends(&querystr, "."); smart_str_appends(&querystr, table); the schema name can be obtained from realnamespace collumn (oid) from table pg_class. Expected result: ---------------- pg_insert should include the schema name in the insert sql statement. Actual result: -------------- the schema name is not specify in sql ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=24679&edit=1
