From: SourceForge.net <no...@so...> - 2004-11-23 11:03:57
|
Bugs item #1071610, was opened at 2004-11-23 11:03 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=1071610&group_id=37132 Category: General Group: 3.5 Status: Open Resolution: None Priority: 5 Submitted By: Matt Kynx (kynx) Assigned to: Nobody/Anonymous (nobody) Summary: getSchemas() and PG8 beta 5 Initial Comment: If you click on a database icon on the left after upgrading to postgres 8 beta 5, you get the following error: ERROR: column pn.nsptablespace does not exist In statement: SELECT pn.nspname, pu.usename AS nspowner, pg_catalog.obj_description(pn.oid, 'pg_namespace') AS nspcomment, (SELECT spcname FROM pg_catalog.pg_tablespace pt WHERE pt.oid=pn.nsptablespace) AS tablespace FROM pg_catalog.pg_namespace pn, pg_catalog.pg_user pu WHERE pn.nspowner = pu.usesysid AND nspname NOT LIKE 'pg\_%' AND nspname != 'information_schema' ORDER BY nspname A quick fix is to cut and paste the getSchemas() function from classes/database/Postgres74.php to classes/database/Postgres80.php, though this will lack the 'tablespace' column in the schema display. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=1071610&group_id=37132 |