Thread: How to get trigger oid by trigger name

Hello All        Can any one tell me how can I get triggerOid from triggerName
in c code. I first tried to use SearchSysCache Function but it does
not search o the basis of triggername.

I'm using systable_beginscan() with TriggerConstrNameIndex
and systable_getnext().

BTW, which value are you using as the cacheId
when you call SearchSysCache() for pg_trigger?

I couldn't find a suitable value in syscache.h.

rafaqat ali wrote:
> Hello All
>          Can any one tell me how can I get triggerOid from triggerName
> in c code. I first tried to use SearchSysCache Function but it does
> not search o the basis of triggername.
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
> 


-- 
NAGAYASU Satoshi <nagayasus@nttdata.co.jp>
OpenSource Development Center,
NTT DATA Corp. http://www.nttdata.co.jp/