ID: 24287
Comment by: rorezende at hotmail dot com
Reported By: zive at apollo dot lv
Status: Open
Bug Type: PostgreSQL related
Operating System: Slackware Linux 9
PHP Version: 4.3.3RC2-dev
New Comment:
This occurr because the PHP do not include schema name in pg_insert,
pg_update, pg_delete.
Previous Comments:
------------------------------------------------------------------------
[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
