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