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

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