> From: Mark Buckle [mailto:[EMAIL PROTECTED]]
>
> data-sources is not implemented for ingres, but the local
> database names can be queried from iidbdb.
Yes but that is only local database names, you would have to
query all iidbdb's that can be accessed by Ingres/Net, and I gave
up on that.
> I suppose my question breaks down into into these sub-queries :-
>
> Are there are technical reasons not to issue a database query (against
> iidbdb) to retrieve this information ?
Probably not, but it is horribly version dependent - iidbdb changed
quite a bit between Ingres6.4 and OpenIngres1.2.
> Does the DBI spec require all or nothing as a response to
> this function, ie
> if you cannot be sure of returing information on ALL accessible data
> sources, then return none.
No, but returning half the information is worse than returning none IMHO.
> And as a corollary, if access to iidbdb is not available to
> normal users at
> a particular site, then should it not be used at all ?
I dunno.
Our setup has absolutely no local databases, all databases are on
dedicated database servers, so querying iidbdb would return nothing.
So I haven't had the inclination to try to get the information.
The mind boggles at the thought of trying to get the Ingres/Net
information out of netu, access iidbdb at all remote servers and
return the list af available databases.
I feel that the effort can be better used elsewhere (eg porting
DBD::Ingres fra Esql/C to Ingres-API, adding procedure calls,
repeated statement support or any of the other project in
my TODO list ;-}
--
Henrik Tougaard, Copenhagen, Denmark
DBD::Ingres maintainer.
"The first rule of Perl Club is, we don't talk about Perl Club"
- Dave Cross at YAPC::Europe 2.0.0
