Cc: pgsql
Sent: Thu, March 31, 2011 6:41:27 PM
Subject: Re: [GENERAL] stack depth limit exceeded
salah jubeh writes:
> Hello,
>
> I have written this function which is simply returns the entities which
> depends
>on a certain entity. It works fine if the
> dependency tree is not
salah jubeh writes:
> Hello,
>
> I have written this function which is simply returns the entities which
> depends on a certain entity. It works fine if the
> dependency tree is not long. However, If I have an entity which are linked to
> many other entities I get
>
> stack depth limit exceeded
If you are working with Postgres version >= 8.4, you should look at the WITH
RECURSIVE (called recursive CTEs) feature:
http://www.postgresql.org/docs/8.4/static/queries-with.html
Regards,
On Thu, Mar 31, 2011 at 12:19 PM, salah jubeh wrote:
>
>
> Hello,
>
> I have written this function which
Hello,
I have written this function which is simply returns the entities which depends
on a certain entity. It works fine if the dependency tree is not long. However,
If I have an entity which are linked to many other entities I get
stack depth limit exceeded
HINT: Increase the configurat
On 5 September 2010 10:13, Ovid wrote:
> I'm getting the following error from Postgres:
>
> ERROR: stack depth limit exceeded
> HINT: Increase the configuration parameter "max_stack_depth", after ensuring
> the platform's stack depth limit is adequate.
> CONTEXT: SQL statement "UPDATE _test_
I'm getting the following error from Postgres:
ERROR: stack depth limit exceeded
HINT: Increase the configuration parameter "max_stack_depth", after ensuring
the platform's stack depth limit is adequate.
CONTEXT: SQL statement "UPDATE _test_changed_table SET updates = updates + 1
WHERE
On Mon, Aug 29, 2005 at 01:45:32PM +1000, Jamie Deppeler wrote:
>
> CREATE TRIGGER "updateContact" AFTER INSERT OR UPDATE
> ON FOR EACH ROW
> EXECUTE PROCEDURE "contacts"."addContactField"();
Please show the actual commands that you're running; the above fails
with a syntax error because it's mis
I think that you forgot the table name.
CREATE TRIGGER "updateContact" AFTER INSERT OR UPDATE
ON contacts FOR EACH ROW
EXECUTE PROCEDURE "contacts"."addContactField"();
Frank
Jamie Deppeler wrote:
What i am trying to do is update the field contact with field values
in firstname and lastname
What i am trying to do is update the field contact with field values in
firstname and lastname
Trigger
CREATE TRIGGER "updateContact" AFTER INSERT OR UPDATE
ON FOR EACH ROW
EXECUTE PROCEDURE "contacts"."addContactField"();
Procedure
CREATE OR REPLACE FUNCTION "contacts"."addContactField" ()
Jamie Deppeler <[EMAIL PROTECTED]> writes:
> At the moment i am trying to execute a very simple function but i am
> getting the following error stack depth limit exceeded
You didn't really show the complete context, but seeing that this is a
trigger and it's trying to do an "UPDATE person" intern
On Mon, Aug 29, 2005 at 12:01:59PM +1000, Jamie Deppeler wrote:
> At the moment i am trying to execute a very simple function but i am
> getting the following error stack depth limit exceeded
That's often a sign of infinite recursion, i.e., a function that
keeps calling itself, either directly or
At the moment i am trying to execute a very simple function but i am
getting the following error stack depth limit exceeded
function
CREATE OR REPLACE FUNCTION "contacts"."addContactField" () RETURNS
trigger AS
$body$
begin
update contacts.person
set "contact" = new.firstname
where person.
12 matches
Mail list logo
