Re: Patch for PLPYTHONU - adding TD["relname"]

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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073