Thread: Triggers

Triggers

From
Steve Tucknott
Date:
PostrgreSQL 7.4.5

Stupid question - how do you see triggers? I have created various
triggers but I can't see how to list them (I think I've seen them
somewhere before but can't think where).
Is the only location pg_trigger? I though there was a '\' command in
psql.....




Re: Triggers

From
Olivier Thauvin
Date:
Le Sunday 17 April 2005 15:21, vous avez écrit :
> PostrgreSQL 7.4.5
>
> Stupid question - how do you see triggers? I have created various
> triggers but I can't see how to list them (I think I've seen them
> somewhere before but can't think where).
> Is the only location pg_trigger? I though there was a '\' command in
> psql.....

\d TABLE

At the end, if the table have a trigger, it is show, like here (in french
sorry):

rpm2sql=# \d rpm
                                      Table «public.rpm»
  Colonne   |           Type           |                    Modificateurs
------------+--------------------------+------------------------------------------------------
 key        | integer                  | not null default
nextval('public.rpm_key_seq'::text)
[...]
Index :
    «rpm_pkey» PRIMARY KEY, btree ("key")
[...]
Contraintes de clés secondaires :
    «rpm_pathkey_fkey» FOREIGN KEY (pathkey) REFERENCES path("key")
Déclencheurs :
    reapheader AFTER DELETE OR UPDATE ON rpm FOR EACH ROW EXECUTE PROCEDURE
reapheader()

The last line is a trigger.

Attachment

Re: Triggers

From
Steve Tucknott
Date:
Olivier,
Thank you. I had done that and I had expected to see the triggers as I
'assuimed' they had been created - when they weren't there, I thought
that I was using the wrong 'tool' - the fact was that the triggers
weren't on the table!

On Sun, 2005-04-17 at 14:26, Olivier Thauvin wrote:
> Le Sunday 17 April 2005 15:21, vous avez écrit :
> > PostrgreSQL 7.4.5
> >
> > Stupid question - how do you see triggers? I have created various
> > triggers but I can't see how to list them (I think I've seen them
> > somewhere before but can't think where).
> > Is the only location pg_trigger? I though there was a '\' command in
> > psql.....
>
> \d TABLE
>
> At the end, if the table have a trigger, it is show, like here (in french
> sorry):
>
> rpm2sql=# \d rpm
>                                       Table «public.rpm»
>   Colonne   |           Type           |                    Modificateurs
> ------------+--------------------------+------------------------------------------------------
>  key        | integer                  | not null default
> nextval('public.rpm_key_seq'::text)
> [...]
> Index :
>     «rpm_pkey» PRIMARY KEY, btree ("key")
> [...]
> Contraintes de clés secondaires :
>     «rpm_pathkey_fkey» FOREIGN KEY (pathkey) REFERENCES path("key")
> Déclencheurs :
>     reapheader AFTER DELETE OR UPDATE ON rpm FOR EACH ROW EXECUTE PROCEDURE
> reapheader()
>
> The last line is a trigger.
--


Regards,

Steve Tucknott
ReTSol Ltd

DDI    01903 828769
MOBILE    07736715772