> -----Original Message----- > From: Jean-Michel POURE [mailto:[EMAIL PROTECTED]] > Sent: 07 April 2001 15:24 > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > Subject: [pgAdmin-hackers] PL/pgSQL IDE project > > > Hello all, > > I would like to inform you all that I am currently working on the > implementation of PL/pgSQL packages on both server-side > (PostgreSQL 7.1) > and client-side (PgAdmin). > The idea is to add an PL/pgSQL Integrated Development Environment to > pgadmin. Help and suggestions needed. If someone is already > working on a > similar project, let me know how I can help. For discussion, please > register on mailto:[EMAIL PROTECTED] mailing > list. Help and > suggestions needed ! Hi Jean-Michel, Sounds great. My only concern is that you consider the way different code has already been implemented in pgAdmin eg: 1) Any server side objects (SSOs) such as tables, functions or views should be prefixed 'pgadmin_'. There is a mechanism in place in basSQL.bas which will autorepair/upgrade SSOs. In the case of upgrades there is an SSO version number stored in basGlobal.bas. If this doesn't match the version number in the pgadmin_param table then an upgrade will occur. 2) Use the same error handling that is already implemented elsewhere. Where applicable, be sure to reuse existing code like the SQL Wizard - no point in writing another one! Good luck, Regards, Dave. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html