> -----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.