Re: writting a large store procedure - Mailing list pgsql-general

From Rodríguez Rodríguez, Pere
Subject Re: writting a large store procedure
Date
Msg-id B35596C2EFF3D2118EE100A0C94B2A60014BFBD8@palamos_nt
Whole thread Raw
In response to writting a large store procedure  ("Rodríguez Rodríguez, Pere" <prr@hosppal.es>)
List pgsql-general
 
-----Mensaje original-----
De: Bob [mailto:luckyratfoot@gmail.com]
Enviado el: viernes 3 de junio de 2005 23:34
Para: Rodríguez Rodríguez, Pere
CC: pgsql-general@postgresql.org
Asunto: Re: [GENERAL] writting a large store procedure

Well first off can you break those 700 lines out into more stored functions? 

No, I can't. Is a stored procedure with a lot of particularities.
 
 
Maybe you have logic that would be best in its own function and than call one function from another. Makes testing many times easier.  I always think in small chuncks when I write code.
 
Once code gets to be more than a few pages it can become hell to debug and work with.  Plus breaking it out might allow you to use that same logic in other parts of your system because it will be stand alone piece of logic/code.

 
On 6/2/05, "Rodríguez Rodríguez, Pere" <prr@hosppal.es> wrote:

Hello,

I'm writing a large store procedures (more than 700 lines) and I have much problems to debug it. How can I debug it easily?

I use pgAdmin, is there another editor (free software) that permit write large store procedure more easily?

Thanks in advance.

pere


pgsql-general by date:

Previous
From: John Sidney-Woollett
Date:
Subject: Download mirrors not found?
Next
From: Russ Brown
Date:
Subject: Re: PG Lightning Admin running on Linux via WINE 2005524