|
php.net | support | documentation | report a bug | advanced search | search howto | statistics | random bug | login |
PatchesPull RequestsHistoryAllCommentsChangesGit/SVN commits
[2003-06-22 14:24 UTC] zive at apollo dot lv
[2003-07-22 09:46 UTC] rorezende at hotmail dot com
[2003-07-22 11:46 UTC] iliaa@php.net
[2011-01-01 23:11 UTC] jani@php.net
-Package: Feature/Change Request
+Package: PostgreSQL related
[2012-03-31 05:21 UTC] yohgaki@php.net
-Assigned To:
+Assigned To: yohgaki
[2013-08-06 22:22 UTC] yohgaki@php.net
-Status: Assigned
+Status: Closed
[2013-08-06 22:22 UTC] yohgaki@php.net
|
|||||||||||||||||||||||||||||||||||||
Copyright © 2001-2025 The PHP GroupAll rights reserved. |
Last updated: Thu Oct 30 18:00:02 2025 UTC |
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