#24679 [Fbk->NoF]: pg_insert problem!
ID: 24679
Updated by: sniper@php.net
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] sniper@php.net
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
Thread (9 messages)