From: zive at apollo dot lv
Operating system: Slackware Linux 9
PHP version: 4.3.2
PHP Bug Type: PostgreSQL related
Bug description: Using user defined Domains
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 bug report at http://bugs.php.net/?id=24287&edit=1
--
Try a CVS snapshot: http://bugs.php.net/fix.php?id=24287&r=trysnapshot
Fixed in CVS: http://bugs.php.net/fix.php?id=24287&r=fixedcvs
Fixed in release: http://bugs.php.net/fix.php?id=24287&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=24287&r=needtrace
Try newer version: http://bugs.php.net/fix.php?id=24287&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=24287&r=support
Expected behavior: http://bugs.php.net/fix.php?id=24287&r=notwrong
Not enough info: http://bugs.php.net/fix.php?id=24287&r=notenoughinfo
Submitted twice: http://bugs.php.net/fix.php?id=24287&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=24287&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=24287&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=24287&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=24287&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=24287&r=gnused
