How to get trigger oid by trigger name

Started by rafaqat aliover 20 years ago2 messages
#1rafaqat ali
rafaqat.ali@gmail.com

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.

#2Satoshi Nagayasu
nagayasus@nttdata.co.jp
In reply to: rafaqat ali (#1)
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@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/