On Wednesday 11 February 2004 15:56, C G wrote: > 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'']) I know nothing of pl-python, but I don't suppose this is a trigger function on table t1 is it? Or, does a trigger on t1 activate an insert on t2, which inserts on t1, which... -- Richard Huxton Archonet Ltd ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)