Edit report at https://bugs.php.net/bug.php?id=24287&edit=1
ID: 24287
Updated by: yohg...@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] il...@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
