Column pg_tablespace.spclocation is removed in Postgresql 9.2

[GoogleCodeExporter]

What steps will reproduce the problem?
1. Run javamelody against postgresql 9.2
2. Go to "Database" under "System information"
3. Select "Tablespaces" from drop down.

What is the expected output? What do you see instead?
Expected is a table of data. I get an error saying "ERROR: column 'spclocation' 
does not exist."

What version of the product are you using? On what application server, JDK,
operating system?
Fedora 18. Postgresql 9.2. Tomcat 7. OpenJDK1.7

Please provide any additional information below.
http://www.postgresql.org/message-id/1334867818.2281.15.camel@localhost.localdom
ain

Removing "spclocation" from the query in databaseInformations.properties:10 
worked for me. Another option would be detecting the postgresql version and use 
different queries accordingly.

Original issue reported on code.google.com by u.martin...@gmail.com on 4 Apr 2013 at 12:57

[GoogleCodeExporter]

Also: pg_database.datconfig was removed in postgresql 9. Used in "System 
information" -> "Database" -> "Databases"

http://www.postgresql.org/message-id/4C992007.4050409@lelarge.info

Original comment by u.martin...@gmail.com on 4 Apr 2013 at 1:02

[GoogleCodeExporter]

This is now fixed, I have removed both columns from the reports.
It is committed in trunk (revision 3349) and it is ready for the next release 
(1.45).

I have made a new build from the current trunk and it is available at:
http://javamelody.googlecode.com/files/javamelody-20130404.jar

Original comment by evernat@free.fr on 4 Apr 2013 at 9:04

• Changed state: Fixed

[GoogleCodeExporter]

Wow, that was fast!

Thanks a bunch!

Original comment by u.martin...@gmail.com on 5 Apr 2013 at 5:35