Обсуждение: Bug: Constraint Trigger - created with pgadmin - is not visible and missing in SQL Pane / Create Script

Поиск
Список
Период
Сортировка

I created a new constraint trigger via pgadmin user interface:

 

Right click on table -> New Object -> New Trigger

Checked “Constraint Trigger” (on Definition Tab)

 

This Trigger is not visible in pgadmin.

 

On SQL pane and Create Script this trigger is missing.

 

Trigger works / Trigger Function is fired.

 

When I check this with phppgadmin I can see the trigger. Export in phppgadmin includes the trigger.

 

SQL Statement for the trigger (from phppgadmin Export) is

 

--
-- Name: … ; Type: TRIGGER; Schema:  … ; Owner: …
--

CREATE CONSTRAINT TRIGGER <trigger-name> AFTER INSERT ON <table-name> NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE <trigger-function>;

 

From my understanding this trigger should be listed in Table Constraints and should be included in Create Script.

 

PostgreSQL 9.1.3 on x86_64-pc-linux-gnu, compiled by gcc-4.6.real (Ubuntu/Linaro 4.6.1-9ubuntu3) 4.6.1, 64-bit (installed via Ubuntu package 9.1.3-0ubuntu0.11.10)

pgAdmin 1.14.2 (Feb 24 2012, rev: REL-1_14_2)

 

Regards, Michael

 

 

Re: Bug: Constraint Trigger - created with pgadmin - is not visible and missing in SQL Pane / Create Script

От
Guillaume Lelarge
Дата:
On Mon, 2012-04-30 at 13:02 +0000, Michael Brux wrote:
> I created a new constraint trigger via pgadmin user interface:
> 
> Right click on table -> New Object -> New Trigger
> Checked "Constraint Trigger" (on Definition Tab)
> 
> This Trigger is not visible in pgadmin.
> 
> On SQL pane and Create Script this trigger is missing.
> 

Yes, you're right. The SQL statement is now fixed. I just pushed the
patch.

Thanks for your report.


-- 
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com