pg_trigger.tgtype question

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

Responses

Browse pgsql-hackers by date

  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?