Re: Information Schema DBMS VERSION wrong - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Information Schema DBMS VERSION wrong
Date
Msg-id 12922.1122611304@sss.pgh.pa.us
Whole thread Raw
In response to Information Schema DBMS VERSION wrong  (Michael Fuhr <mike@fuhr.org>)
Responses Re: Information Schema DBMS VERSION wrong  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Michael Fuhr <mike@fuhr.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


pgsql-hackers by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: Race conditions, race conditions!
Next
From: Peter Eisentraut
Date:
Subject: Re: [PATCHES] Patch to fix plpython on OS X