From: | Brian <brian(at)mail(dot)pantalaimon(dot)net> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | pg_trigger.tgtype question |
Date: | 2003-04-07 19:39:04 |
Message-ID: | Pine.LNX.4.50.0304071536270.3865-100000@lyra |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I was wondering if there was a way, given the information in pg_trigger,
specifically pg_trigger.tgtype, to find out on what events a trigger is
fired, and whether it is fired before or after those events.
I've looked through the code a little in src/backend/commands/trigger.c
and think I'm on the right track, thanks to some help given to me on the
#postgresql irc channel, but I'm not much of a C programmer and I'm not
very familiar with postgresql internals.
Basically I'm looking for a way to connect to a postgres database and get
back all the stored procs (which I can do), triggers (which I can do), and
when those triggers fire (which I haven't figured out).
Thanks.
Brian Knox
brian(at)mail(dot)pantalaimon(dot)net
From | Date | Subject | |
---|---|---|---|
Next Message | cbbrowne | 2003-04-07 19:44:06 | Re: Anyone know why PostgreSQL doesn't support 2 phase execution? |
Previous Message | Greg Stark | 2003-04-07 19:36:10 | Re: No merge sort? |