Re: pl/pythonu

From: Barbara Lindsey <blindsey(at)cog(dot)ufl(dot)edu>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: C G <csgcsg39(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: pl/pythonu
Date: 2004-02-11 17:48:33
Message-ID: 402A6AF1.5070407@cog.ufl.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

You could write a rule to trigger a record into a table as well.

Richard Huxton wrote:
> 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...

--
Barbara E. Lindsey,
COG RDC
Phone: (352) 392-5198 ext. 314 Fax: (352) 392-8162

----
CONFIDENTIALITY NOTICE: The information contained in this electronic
message is legally privileged and confidential and intended only for the
use of the individual(s) or entity(ies) named above. If the reader of
this message is not the intended recipient, you are hereby notified that
any dissemination, distribution, or copying of this email or any of it's
components is strictly prohibited. If you have received this email in
error, please contact the sender.
----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Barbara Lindsey 2004-02-11 17:50:31 Re: pl/pythonu
Previous Message Iker Arizmendi 2004-02-11 17:35:59 Re: Function parameters of rowtype