| Keith Worthington 2005-04-26, 1:24 pm |
| Hi All,
I have noticed that when reviewing a trigger function using pgadmin the
displayed schema is incorrect.
pgadmin3 display:
CREATE TRIGGER tgr_update_tbl_curre
nt_allocated
AFTER INSERT OR UPDATE OR DELETE
ON sales_order.tbl_item_bom
FOR EACH STATEMENT
EXECUTE PROCEDURE sales_order. tf_update_tbl_curren
t_allocated();
psql description:
TESTDB=# \d sales_order.tbl_item_bom
Table "sales_order.tbl_item_bom"
[snip]
Triggers:
tgr_update_tbl_curre
nt_allocated AFTER INSERT OR DELETE OR UPDATE ON
sales_order.tbl_item_bom FOR EACH STATEMENT EXECUTE PROCEDURE
inventory. tf_update_tbl_curren
t_allocated()
The display seems to assume that the called procedure is in the same schema as
the table that the trigger is built on.
Kind Regards,
Keith
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
|