emacs, the tags system, and etags can support tcl, pl/sql and acs development easily. Here's
http://www.arsdigita.com/bboard/q-and-a-fetch-msg?msg_id=000Jr9 a discussion of tags, tcl, and the acs. I imagine it shouldn't be too difficult to add support for pgsql.