Web pgadmin.org
 Home 
 ·  ·  ·  ·  ·  ·  · 
Error in display of schema qualified procedure

Error in display of schema qualified procedure



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_current_allocated
  AFTER INSERT OR UPDATE OR DELETE
  ON sales_order.tbl_item_bom
  FOR EACH STATEMENT
  EXECUTE PROCEDURE sales_order.tf_update_tbl_current_allocated();

psql description:
TESTDB=# \d sales_order.tbl_item_bom
                   Table "sales_order.tbl_item_bom"
[snip]
Triggers:
    tgr_update_tbl_current_allocated AFTER INSERT OR DELETE OR UPDATE ON
sales_order.tbl_item_bom FOR EACH STATEMENT EXECUTE PROCEDURE
inventory.tf_update_tbl_current_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



Home | Main Index | Thread Index

top