Re: no meaningful way to determine fe or be version?

> Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> > Yes, should we return the client or server version from the interface?
> > If we return the server version, how does someone query the client version?
>
> sorry, yes. the client-side interfaces (DatabaseMetaData.getDriver*)
> are actually fine - they return a major/minor version that have been
> getting manually updated (they're much more visible, being in
> org/postgresql/Driver.java). the server-side interfaces
> (DatabaseMetaData.getDatabase{Name,Version}) are the ones that aren't
> tied to the server, return hardcoded strings and haven't been getting
> updated regularly.

Good news. Someone supplied a patch to getDatabaseProductVersion() that
properly does the SELECT version(); and returns the result. It will
appear in 7.1.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026