Re: Recursive PLPGSQL function? - Mailing list pgsql-general

From Mark Cave-Ayland
Subject Re: Recursive PLPGSQL function?
Date
Msg-id 8F4A22E017460A458DB7BBAB65CA6AE5026628@openmanage
Whole thread Raw
In response to Recursive PLPGSQL function?  ("Mark Cave-Ayland" <m.cave-ayland@webbased.co.uk>)
List pgsql-general
> -----Original Message-----
> From: DeJuan Jackson [mailto:djackson@speedfc.com]
> Sent: 04 August 2004 17:56
> To: Mark Cave-Ayland
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] Recursive PLPGSQL function?
>
>
> If I'm not mistaken you have an infinit recursion because you
> are always
> pulling the same id (whatever _id starts at) throughout each
> function call.
>
> Postgres is most likely killing the functions when it's hits
> some stack
> or memory limit.


Ahhh yes I got it now :) I was pulling in the wrong field from the inner
nested record set which was causing it to call itself as you suggested.
I did suspect this and put a RAISE NOTICE at the beginning of the
function to try and debug it, but the message was only displayed perhaps
once every several hundred lines of output between many "CONTEXT:
PL/pgSQL function "findsubcategories" line 15 at for over" messages,
which made me think that something was being overwritten in the
recursion (for an infinite recursion I would have expected the screen to
fill with hundreds of RAISE NOTICE message until something died).


Anyway, it all seems to be working now - thanks very much for the help.

Mark.

---

Mark Cave-Ayland
Webbased Ltd.
Tamar Science Park
Derriford
Plymouth
PL6 8BX
England

Tel: +44 (0)1752 764445
Fax: +44 (0)1752 764446


This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender. You
should not copy it or use it for any purpose nor disclose or distribute
its contents to any other person.



pgsql-general by date:

Previous
From: "Uwe C. Schroeder"
Date:
Subject: Re: Creating an hourly backup
Next
From: David Garamond
Date:
Subject: case insensitive sorting & searching in oracle 10g