#24287 [Opn]: Using user defined Domains

ID: 24287 User updated by: zive at apollo dot lv Reported By: zive at apollo dot lv Status: Open Bug Type: PostgreSQL related Operating System: Slackware Linux 9 -PHP Version: 4.3.2 +PHP Version: 4.3.3RC2-dev New Comment: I tested on newest PHP version 4.3.3RC2-dev and that problesm still exists Previous Comments: ------------------------------------------------------------------------ [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