Re: sql_implementation_info still contains old value - Mailing list pgsql-hackers

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,
Suporte24x7 e Treinamento