Req #24287 [Asn->Csd]: Using user defined Domains

Edit report at https://bugs.php.net/bug.php?id=24287&edit=1 ID: 24287 Updated by: yohgaki@php.net Reported by: zive at apollo dot lv Summary: Using user defined Domains -Status: Assigned +Status: Closed Type: Feature/Change Request Package: PostgreSQL related Operating System: Slackware Linux 9 PHP Version: 4.3.3RC2-dev Assigned To: yohgaki Block user comment: N Private report: N New Comment: Fix was done already. Previous Comments: ------------------------------------------------------------------------ [2003-07-22 11:46:11] iliaa@php.net 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. ------------------------------------------------------------------------ [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 https://bugs.php.net/bug.php?id=24287&edit=1