Re: System catalog for triggers - Mailing list pgsql-admin

From Tom Lane
Subject Re: System catalog for triggers
Date
Msg-id 26431.1063288958@sss.pgh.pa.us
Whole thread Raw
In response to System catalog for triggers  ("A.Bhuvaneswaran" <bhuvan@symonds.net>)
List pgsql-admin
"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

pgsql-admin by date:

Previous
From: Wim Bertels
Date:
Subject: Pam Ldap (debian) problem
Next
From: Tom Lane
Date:
Subject: Re: `__builtin_va_alist' undeclared