[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 (Settings changed) made by ioguix
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: Closed
Resolution: Fixed
Priority: 5
Private: No
Submitted By: Dante Lopez (dqlopez)
Assigned to: J.Guillaume (ioguix) de Rorthais (ioguix)
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

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

Comment By: J.Guillaume (ioguix) de Rorthais (ioguix)
Date: 2012-09-21 10:18

Message:
Hello,

phpPgAdmin 5.0 is officialy not compatible with pg 9.2.

This regression has been fixed in our current development branch of
phpPgAdmin. The next release of phpPgAdmin should be released soon.

Thank you for your bug report.

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

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