[ppa-help] [ phppgadmin-Bugs-3570272 ] pg_tablespace.spclocation column removed in 9.2

[SourceForge.net <no...@so...>]

Bugs item #3570272, was opened at 2012-09-20 16:38
Message generated for change (Tracker Item Submitted) made by dqlopez
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: 5.0.3
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Dante Lopez (dqlopez)
Assigned to: Nobody/Anonymous (nobody)
Summary: pg_tablespace.spclocation column removed in 9.2

Initial Comment:
phpPgAdmin 5.0.3 (PHP 5.4.6-2~precise+1)

Can't create database/table/schema on the current build if used with Postgres 9.2. Refer to this mailing list issues:

http://archives.postgresql.org/pgsql-bugs/2012-06/msg00203.php
http://archives.postgresql.org/pgsql-bugs/2012-06/msg00202.php
http://archives.postgresql.org/pgsql-bugs/2012-06/msg00201.php
http://archives.postgresql.org/pgadmin-hackers/2012-04/msg00045.php

SQL error:
ERROR:  column "spclocation" does not exist
LINE 1: ...pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocatio...
                                                             ^
In statement:
SELECT spcname, pg_catalog.pg_get_userbyid(spcowner) AS spcowner, spclocation,
(SELECT description FROM pg_catalog.pg_shdescription pd WHERE pg_tablespace.oid=pd.objoid) AS spccomment
FROM pg_catalog.pg_tablespace WHERE spcname NOT LIKE $$pg\_%$$ ORDER BY spcname

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=418980&aid=3570272&group_id=37132