I mentioned this before but.
If PGadmin loses connection even momentarily it causes a crash. First
you get a syscall error and then it crashes (details below) and has to
be restarted.
Process: pgAdmin3 [5658]
Path:/Applications/pgAdmin3.app/Contents/MacOS/pgAdmin3
Identifier:
Did some research on system catalogs and how to retrieve constraint triggers:
Internal triggers (addressed in "CREATE CONSTRAINT TRIGGER in SQL pane (pgAdmin
1.14.1)" from Thu, 15 Dec 2011 15:39:37 +0200 ) have tgisinternal set to true
in table pg_trigger.
Constraint triggers (I was talking ab
On Mon, 2012-04-30 at 13:02 +, 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
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 fi