Re: Patch for PLPYTHONU - adding TD["relname"] - Mailing list pgsql-patches

From Bruce Momjian
Subject Re: Patch for PLPYTHONU - adding TD["relname"]
Date
Msg-id 200510131709.j9DH9vc12030@candle.pha.pa.us
Whole thread Raw
In response to Patch for PLPYTHONU - adding TD["relname"]  (Sokolov Yura <falcon@intercable.ru>)
List pgsql-patches
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

pgsql-patches by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Kerberos brokenness and oops question in 8.1beta2
Next
From: Bruce Momjian
Date:
Subject: Re: Docs for PITR and full_page_writes interaction