Re: Information Schema DBMS VERSION wrong

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Information Schema DBMS VERSION wrong
Date: 2005-07-29 04:28:24
Message-ID: 12922.1122611304@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Michael Fuhr <mike(at)fuhr(dot)org> writes:
> The following query doesn't return the version of PostgreSQL currently
> running, but rather the version of initdb that initialized the cluster:

> SELECT character_value
> FROM information_schema.sql_implementation_info
> WHERE implementation_info_name = 'DBMS VERSION';

> Is that the intended or desired behavior?

Not sure if it was really thought about, but seeing that (a) you can get
the current version from "select version()" and (b) there isn't any
other way to get the initdb version, it seems like this behavior is
fine.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2005-07-29 14:31:25 Re: [PATCHES] Patch to fix plpython on OS X
Previous Message Bruce Momjian 2005-07-29 03:23:55 Re: [HACKERS] O_DIRECT for WAL writes