There is a better editor available:
http://www.amsoftwaredesign.com
http://www.amsoftwaredesign.com/lightning_admin.php
I invite you to try it out :-)
It provides all the find/replace goto line number etc, many of the
features of a IDE such as Delphi 2006 or VS, it also has super nice
tabbed based MDI.
We also offer code completion for schemas, user functions and built in
functions.
I will probably get flamed but PG Admin III's function editing is not
much better than notepad.
The server provides the error messages, and on versions before 8.0 they
did not do much checking at all.
Version 8.1 does the best checking and I advise you to upgrade your
server, it's not that difficult.
Another thing to keep in mind is if you restore a dump from 7.x to 8.x
it will not do any checking unless you make a tweak, see this article:
http://www.milwaukeesoft.com/forums/viewtopic.php?t=83
As far as I know this affects 8.0 and 8.1, I am sure someone will
correct me if I am wrong :-)
Hope this helps,
--
Tony Caduto
http://www.amsoftwaredesign.com
Home of PG Lightning Admin for Postgresql 8.x
Ken Winter wrote:
>
> Is a better PL/pgSQL editor / debugger than pgAdmin III or phpPgAdmin
> available anywhere?
>
>
> As editors, the two pgAdmin tools apparently don’t offer elementary
> functions such as find and replace, which means I have to slurp my
> code out into a text editor when I really need these things.
>
> So I guess my questions are:
>
> * Is it the case that the pgAdmin tools actually do offer these
> features, but I just haven’t found them yet? If so, can you show
> me where they are?
> * Are these functions available through add-ons to either pgAdmin
> tool? If so, where can I get these add-ons?
> * Are there other PL/pgSQL editors that provide these functions?
> If so, what? Obviously, I’d prefer a free one, but would pay for
> one if necessary.
>
> ~ TIA
>
> ~ Ken
>