Обсуждение: System catalog for triggers

Hi,

This is my second post.

I am using postgresql 7.3.2 on redhat linux 7.3.

Where does postgresql store tg_op and tg_when details for a trigger? If i
am right, it is not in pg_trigger catalog.

TIA.

regards,
bhuvaneswaran

"A.Bhuvaneswaran" <bhuvan@symonds.net> writes:
> Where does postgresql store tg_op and tg_when details for a trigger? If i
> am right, it is not in pg_trigger catalog.

No, you're not right.  It's encoded in tgtype somehow; you'll have to
look at the trigger code for details (see src/include/catalog/pg_trigger.h
in particular).

            regards, tom lane