Skip site navigation (1) Skip section navigation (2)

Re: Triggers

From: Steve Tucknott <steve(at)retsol(dot)co(dot)uk>
To: PostGreSQL <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Triggers
Date: 2005-04-17 14:16:36
Message-ID: 1113747397.1240.59.camel@retsol1 (view raw or flat)
Thread:
Lists: pgsql-novice
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



In response to

pgsql-novice by date

Next:From: Nurlan Mukhanov (AL/EKZ)Date: 2005-04-18 04:50:55
Subject: Postgresql works too slow
Previous:From: Olivier ThauvinDate: 2005-04-17 13:26:18
Subject: Re: Triggers

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group