From: Bruce Momjian <pgman@candle.pha.pa.us>
Message-Id: <200011250431.XAA00531@candle.pha.pa.us>
Subject: Re: no meaningful way to determine fe or be version?
In-Reply-To: <200011162052.eAGKqih26908@faerie.CS.Berkeley.EDU>
	"from Paul M. Aoki at Nov 16, 2000 12:52:43 pm"
To: "Paul M. Aoki" <aoki@acm.org>
Date: Fri, 24 Nov 2000 23:31:13 -0500 (EST)
CC: pgsql-bugs@postgresql.org
MIME-Version: 1.0
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=US-ASCII

> Bruce Momjian <pgman@candle.pha.pa.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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026