Postgres Pro
Downloads
Home   >   mailing lists

Thread: sql_implementation_info still contains old value

sql_implementation_info still contains old value

From
"Erik Rijkers"
Date:
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

Re: sql_implementation_info still contains old value

From
Euler Taveira
Date:
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

Re: sql_implementation_info still contains old value

From
"David Johnston"
Date:
> -----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.

Re: sql_implementation_info still contains old value

From
Euler Taveira
Date:
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