This has been saved for the 8.2 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold
--------------------------------------------------------------------------- Sokolov Yura wrote: > Excuse my English. > Patch allows to get triggers table name in the trigger TD['relname']. > Usefull when same trigger function applied to different tables. > patch for plpython.c in Postgres 8.1 beta (diff was applied to) > works also in Postgres 8.0.3 when placed in the same function (may be > different line numbers) > > --- plpython-old.c 2005-07-10 08:56:55.000000000 +0400 > +++ plpython.c 2005-10-04 12:03:36.000000000 +0400 > @@ -582,7 +582,8 @@ PLy_trigger_build_args(FunctionCallInfo > *pltevent, > *pltwhen, > *pltlevel, > - *pltrelid; > + *pltrelid, > + *pltrelname; > PyObject *pltargs, > *pytnew, > *pytold; > @@ -606,6 +607,12 @@ PLy_trigger_build_args(FunctionCallInfo > Py_DECREF(pltrelid); > pfree(stroid); > > + stroid = SPI_getrelname(tdata->tg_relation); > + pltrelname = PyString_FromString(stroid); > + PyDict_SetItemString(pltdata, "relname", pltrelname); > + Py_DECREF(pltrelname); > + pfree(stroid); > + > if (TRIGGER_FIRED_BEFORE(tdata->tg_event)) > pltwhen = PyString_FromString("BEFORE"); > else if (TRIGGER_FIRED_AFTER(tdata->tg_event)) > > > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings