Pgadmin - Bug/Feature request: Triggers

Author

Bug/Feature request: Triggers

Bath, David

2005-09-21, 8:24 pm

Folks,

Version of pgadmin3 : 1.2.2
Version of postgresql : 8.0.3
Operating Platform : SuSE 9.3 Professional IA-32
Summary: Triggers subtree missing from schema item
Impact (1-10): 5
Type of impact: Inconvenient (no information loss)

Long Description:
_ I am having difficulties with creation, editing, and
discovery of triggers, as opposed to trigger functions.

More specifically
a. There seems nowhere in the GUI to issue the following
statement:
CREATE TRIGGER name {BEFORE|AFTER} event
ON table ...
EXECUTE PROCEDURE
b. The only way I can discover triggers is by going
to the "Referenced by" panel for a each particular
function. Even having a list of triggers using
trigger functions in this panel when the
"Trigger Functions" tree item is selected would
make life MUCH easier.

Thanks in advance

--
David T. Bath
dave.bath@unix.net

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Sim Zacks

2005-09-22, 3:23 am

This statement can be generated by clicking on the plus side next to
the table name, clicking where it says triggers(x) and then choosing
New Trigger from the right click menu. (At least this works in the
Windows version)
All the functions that return a trigger are listed in the drop down
list.

Thank You
Sim Zacks
CIO
CompuLab
04-829-0145 - Office
04-832-5251 - Fax

____________________
____________________
____________________
____________________

Folks,

Version of pgadmin3 : 1.2.2
Version of postgresql : 8.0.3
Operating Platform : SuSE 9.3 Professional IA-32
Summary: Triggers subtree missing from schema item
Impact (1-10): 5
Type of impact: Inconvenient (no information loss)

Long Description:
_ I am having difficulties with creation, editing, and
discovery of triggers, as opposed to trigger functions.

More specifically
a. There seems nowhere in the GUI to issue the following
statement:
CREATE TRIGGER name {BEFORE|AFTER} event
ON table ...
EXECUTE PROCEDURE
b. The only way I can discover triggers is by going
to the "Referenced by" panel for a each particular
function. Even having a list of triggers using
trigger functions in this panel when the
"Trigger Functions" tree item is selected would
make life MUCH easier.

Thanks in advance

--
David T. Bath
dave.bath@unix.net

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Sponsored Links