Datum mylanguage_handler(PG_FUNCTION_ARGS){
if (CALLED_AS_TRIGGER(fcinfo))/*do nothing else{ char *proc_source;Datum prosrcdatum;bool
isnull; //get the oid of the functionOid funcOid = fcinfo->flinfo->fn_oid; HeapTuple procTup =
SearchSysCache(PROCOID,ObjectIdGetDatum(funcOid),0, 0,
0);
//get the attribute that holds the function's source
prosrcdatum = SysCacheGetAttr(PROCOID,
procTup,Anum_pg_proc_prosrc, &isnull);
//convert prosrcdatum to C style string
proc_source =
DatumGetCString(DirectFunctionCall1(textout,
prosrcdatum)); if (isnull) elog(ERROR, "null prosrc");else{ elog(INFO,"\n Invoking parser \n");
/*the problem area*/ yyparse(); elog(INFO,"\n parser invoked \n");}
}//end of function
i receive the following error
"server closed the connection unexpectedly This probably means the server terminated
abnormally before or while processing the request.
The connection to the server was lost. Attempting
reset: Failed."
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com