ID: 24287
Updated by: [EMAIL PROTECTED]
Reported By: zive at apollo dot lv
Status: Open
-Bug Type: PostgreSQL related
+Bug Type: Feature/Change Request
Operating System: Slackware Linux 9
PHP Version: 4.3.3RC2-dev
New Comment:
Normally you should specify the schema along with the table name
([schema].[table_name]) when using pg_(insert/update/convert). Therefor
this is not a bug, however I do see the use for this functionality, so
I making this report a feature request.
Previous Comments:
------------------------------------------------------------------------
[2003-07-22 09:46:06] rorezende at hotmail dot com
This occurr because the PHP do not include schema name in pg_insert,
pg_update, pg_delete.
------------------------------------------------------------------------
[2003-06-22 14:24:14] zive at apollo dot lv
I tested on newest PHP version 4.3.3RC2-dev and that problesm still
exists
------------------------------------------------------------------------
[2003-06-22 13:35:59] zive at apollo dot lv
Description:
------------
In PostgreSQL 7.3.2 database I created domain - "public.nauda"
(monetary data type) ar Number (8,2).
I have table on non-public schema - mySchema.myTable with column
'spec_price' with data type "public.nauda".
When I am calling pg_insert(), pg_update or pg_convert, I receive
following error:
Notice: pg_convert(): Unknown or system data type 'nauda' for
'spec_price'. in xxx.php on line n
I am using variable $ids for containing ids (primary key of table)
value if I am editing data, and $ids="new" if I am inserting new datas.
Reproduce code:
---------------
$data = array('proset_ids'=>$cmbProsetIds,
'spec_price'=>$txtSpecPrice,
...
);
if ($ids=="new")
pg_insert($db, "tb_product_of_week", $data);
else
pg_update($db, "tb_product_of_week", $data, array('ids'=>$ids));
$ids = "";
Expected result:
----------------
I am expecting result that data are inserted/updated in database.
Actual result:
--------------
Notice: pg_update(): Unknown or system data type 'nauda' for
'spec_price'. in xxx.php on line n
------------------------------------------------------------------------
--
Edit this bug report at http://bugs.php.net/?id=24287&edit=1
