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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly > -- NAGAYASU Satoshi <[EMAIL PROTECTED]> OpenSource Development Center, NTT DATA Corp. http://www.nttdata.co.jp/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster