-Mensaje original-De: Bob
[mailto:[EMAIL PROTECTED]Enviado el: viernes 3 de junio de
2005 23:34Para: Rodríguez Rodríguez, PereCC:
pgsql-general@postgresql.orgAsunto: Re: [GENERAL] writting a large
store procedure
Well first off can you break those 700 lines out into
Well first off can you break those 700 lines out into more stored functions?
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
Well first off can you break those 700 lines out into more stored functions?
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
Tony Caduto wrote:
Sean,
I am tooting my own horn here, but I would recomend PG Lightning Admin.
It has a incredible function editor (and query editor) that is based on
Synedit(synedit.sourceforge.net), and has full code completion that
includes
all the Postgres built in functions,exception nam
Sean,
I am tooting my own horn here, but I would recomend PG Lightning Admin.
It has a incredible function editor (and query editor) that is based on
Synedit(synedit.sourceforge.net), and has full code completion that includes
all the Postgres built in functions,exception names,types etc etc, and
I have to recommend pgEdit (nearly free and does have a nearly
fully-functional test version).
Sean
On Jun 2, 2005, at 3:57 AM, Rodríguez Rodríguez, Pere 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?
Title: writting a large store procedure
I use EMS postgresql manager
2.8.0.3
- Original Message -
From:
Rodríguez Rodríguez,
Pere
To: pgsql-general@postgresql.org
Sent: Thursday, June 02, 2005 3:57
PM
Subject: [GENERAL] writting a
large store procedure
Title: writting a large store procedure
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
