Re: writting a large store procedure

["Rodríguez Rodríguez, Pere" <prr@xxxxxxxxxx>]

 

-----Mensaje original-----
De: Bob [mailto:luckyratfoot@xxxxxxxxx]
Enviado el: viernes 3 de junio de 2005 23:34
Para: Rodríguez Rodríguez, Pere
CC: pgsql-general@xxxxxxxxxxxxxx
Asunto: Re: 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@xxxxxxxxxx> 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