Information Schema DBMS VERSION wrong

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Information Schema DBMS VERSION wrong
Date: 2005-07-29 03:12:15
Message-ID: 20050729031215.GA25407@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Qingqing Zhou 2005-07-29 03:20:29 Re: Race conditions, race conditions!
Previous Message Mark Wong 2005-07-29 00:00:44 Re: [Testperf-general] dbt2 & opteron performance