Error in display of schema qualified procedure

From: "Keith Worthington" <keithw(at)narrowpathinc(dot)com>
To: "pgAdmin Support" <pgadmin-support(at)postgresql(dot)org>
Subject: Error in display of schema qualified procedure
Date: 2005-04-26 18:18:03
Message-ID: 20050426181141.M25215@narrowpathinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Browse pgadmin-support by date

  From Date Subject
Next Message Francis Labrie 2005-04-27 12:54:59 Compiling latest pgAdmin 3 fails on Red Hat 8
Previous Message Dave Page 2005-04-23 20:08:19 Re: CREATE DATABASE impossible if pgAdmin III is connected to the DB