RE: [pgAdmin-hackers] PL/pgSQL IDE project

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm.poure@freesurf.fr]
> Sent: 07 April 2001 15:24
> To: pgAdmin-hackers@greatbridge.org
> Cc: pgsql-hackers@postgresql.org
> 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:pgadmin-hackers@greatbridge.org 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.