> Dear All,
>
> Could anyone explain why this function does will not work? The error message
> is
> DETAIL: exceptions.RuntimeError: maximum recursion depth exceeded.
>
> CREATE FUNCTION testing() RETURNS trigger AS'
>
> plan=plpy.prepare(''INSERT INTO t1 values ($1)'',[''text''])
> plpy.execute(plan,[''blah''])
> return ''MODIFY''
>
> 'LANGUAGE plpythonu;
Perhaps the plpy.execute is inserting into the same table as the trigger is on? If that's the case, then the trigger will be recursively called over and over until the "maximum recursion depth" is "exceeded".
Yes, that is what is happening. My question is now, if I have a trigger on table t1, how should I write my function to insert 'blah' into my table when it is triggered?
Thanks
Colin
_________________________________________________________________
It's fast, it's easy and it's free. Get MSN Messenger today! http://www.msn.co.uk/messenger
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
