Re: sql_implementation_info still contains old value

On 25-10-2012 15:36, Erik Rijkers wrote:
> I would expect 9.2.1 to contain '09.02.0001' (not '09.02.0000').
>
'09.02.0000' is the initdb'ed version. It seems you upgrade binaries from 9.2
to 9.2.1.

euler=# select version();
version

----------------------------------------------------------------------------------------------
PostgreSQL 9.1.5 on x86_64-unknown-linux-gnu, compiled by gcc (Debian
4.7.1-7) 4.7.1, 64-bit
(1 registro)

euler=# select implementation_info_name,character_value from
information_schema.sql_implementation_info where implementation_info_name =
'DBMS VERSION';
implementation_info_name | character_value
--------------------------+-----------------
DBMS VERSION | 09.01.0002
(1 registro)

It seems we should ignore the last digit or invent a way to update that tuple
according to the new minor version. Another option is document that that
version is the initdb'ed version.

--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento