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