Обсуждение: sql_implementation_info still contains old value
I noticed this in information_schema; it would seem the 'DBMS VERSION' is still the old value: $ psql psql (9.2.1) Type "help" for help. # select version(); version -----------------------------------------------------------------------------------PostgreSQL 9.2.1 on x86_64-unknown-linux-gnu,compiled by gcc (GCC) 4.6.2, 64-bit (1 row) # select * from information_schema.sql_implementation_info where implementation_info_name = 'DBMS VERSION'; -[ RECORD 1 ]------------+------------- implementation_info_id | 18 implementation_info_name | DBMS VERSION integer_value | character_value | 09.02.0000 comments | I would expect 9.2.1 to contain '09.02.0001' (not '09.02.0000'). Unless, of course, I have overlooked some step in the upgrade... Thanks, Erik Rijkers
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
> -----Original Message----- > From: pgsql-hackers-owner@postgresql.org [mailto:pgsql-hackers- > owner@postgresql.org] On Behalf Of Euler Taveira > Sent: Thursday, October 25, 2012 6:59 PM > To: Erik Rijkers > Cc: pgsql-hackers@postgresql.org > Subject: Re: [HACKERS] 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. > > > 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. > If this is the case does pg_upgrade "init-db" for this purpose? David J.
On 25-10-2012 21:05, David Johnston wrote: > If this is the case does pg_upgrade "init-db" for this purpose? > Yes. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte24x7 e Treinamento