Re: Working oin pgAdmin2

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm(dot)poure(at)freesurf(dot)fr]
> Sent: 24 February 2002 23:07
> To: Dave Page
> Cc: pgadmin-hackers(at)postgresql(dot)org
> Subject: Re: Working oin pgAdmin2
>
>
> > I think the most effective way to go would be to write new classes
> > pgSchema.ODBCServer, pgSchema.ODBCTables,
> pgSchema.ODBCTable, and have
> > an ODBCServers collection at the top of the hierarchy, next to
> > pgServer. This can then provide a hierarchy that is compatible with
> > the sort of data we'd expect from an ODBC driver. In the future we
> > could add an OLEDBServers collection in a similar vein.
> Does ODBC provide function list, views, triggers.

No, (well, views, yes). But that's the problem, functions are very dbms
specific. The only way we could incorporate support for these things is by
building an orSchema, an msSchema, an ixSchema... This is a major job that I
do not wish to undertake, though I would consider an ODBC or OLEDB layer. I
think the work involved in getting pgAdmin to work with PostgreSQL 7.3 is
going to be a mammoth task on it's own. the addition of Schemas will cause a
major change in the object hierarchy the effects of which will be felt in
just about every function or subroutine there is.

Regards, Dave.