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