ID: 24679 Updated by: [EMAIL PROTECTED] Reported By: rorezende at hotmail dot com -Status: Feedback +Status: No Feedback Bug Type: PostgreSQL related Operating System: * PHP Version: 4.3.2 Assigned To: helly New Comment:
No feedback was provided. The bug is being suspended because we assume that you are no longer experiencing the problem. If this is not the case and you are able to provide the information that was requested earlier, please do so and change the status of the bug back to "Open". Thank you. Previous Comments: ------------------------------------------------------------------------ [2003-07-16 21:28:37] [EMAIL PROTECTED] Please provide an example script which shows the problem clearly. ------------------------------------------------------------------------ [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
