Re: How to get trigger oid by trigger name

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(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

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