Search Postgresql Archives

Re: writting a large store procedure

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



 
-----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



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux