Re: [GENERAL] pl/pythonu

2004-02-11 Thread Barbara Lindsey
Here's the link for rules. http://www.postgresql.org/docs/7.3/static/rules-insert.html 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 recursi

Re: [GENERAL] pl/pythonu

2004-02-11 Thread Barbara Lindsey
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. CREA

Re: [GENERAL] pl/pythonu

2004-02-11 Thread scott.marlowe
On Wed, 11 Feb 2004, 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' > > > > > > pl

Re: [GENERAL] pl/pythonu

2004-02-11 Thread scott.marlowe
On Wed, 11 Feb 2004, 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

Re: [GENERAL] pl/pythonu

2004-02-11 Thread C G
> 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(

Re: [GENERAL] pl/pythonu

2004-02-11 Thread Mike Mascari
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'']) plpy.execute(plan,[

Re: [GENERAL] pl/pythonu

2004-02-11 Thread Mike Mascari
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'']) plpy.execute(plan,[

[GENERAL] pl/pythonu

2004-02-11 Thread C G
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'']) r