[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 (Comment added) made by 
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: https://www.google.com/accounts ()
Date: 2012-10-25 05:57

Message:
peterireds,

You missed one thing.

Change in Postgres92.php

FROM:

class Postgres84 extends Postgres {

	var $major_version = 8.4;

TO:


class Postgres92 extends Postgres {

	var $major_version = 9.2;

It completes the fix.

Cesar

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

Comment By: J.Guillaume (ioguix) de Rorthais (ioguix)
Date: 2012-10-08 05:55

Message:
...Or just download the snapshot of the current dev branch:

https://github.com/phppgadmin/phppgadmin/zipball/master

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

Comment By: Peter Hfer (peterireds)
Date: 2012-10-06 14:11

Message:
Quick Fix: (worked with my Version (5.0.3) / pg 9.2.1 )

1) change to /classes/database
2) copy "Postgres84.php" to "Postgres92.php"
3) open Connection.php
4) add a line 
                     case '9.2': return 'Postgres92'; break; 
  at // Detect version and choose appropriate database driver  - switch 
5) open "Postgres.php" & copy functions "getTablespaces" + "getTablespace"
6) open "Postgres92.php"  paste functions into the class 
7) replace ", spclocation," with ", pg_tablespace_location(oid) as
spclocation," in both functions

regards

Peter 


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

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