Information Schema DBMS VERSION wrong - Mailing list pgsql-hackers

From Michael Fuhr
Subject Information Schema DBMS VERSION wrong
Date
Msg-id 20050729031215.GA25407@winnie.fuhr.org
Whole thread Raw
Responses Re: Information Schema DBMS VERSION wrong
List pgsql-hackers
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?

sql_implementation_info is a table rather than a view, so its
contents are hardcoded by initdb.  Would it make sense to turn it
into a view?  This is admittedly a minor issue that might not merit
the effort, but it still seems wrong.

-- 
Michael Fuhr
http://www.fuhr.org/~mfuhr/


pgsql-hackers by date:

Previous
From: Mark Wong
Date:
Subject: Re: [Testperf-general] dbt2 & opteron performance
Next
From: "Qingqing Zhou"
Date:
Subject: Re: Race conditions, race conditions!