From: SourceForge.net <no...@so...> - 2004-11-26 18:07:06
|
Bugs item #1071610, was opened at 2004-11-23 11:03 Message generated for change (Comment added) made by kynx 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: 8 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. ---------------------------------------------------------------------- >Comment By: Matt Kynx (kynx) Date: 2004-11-26 18:07 Message: Logged In: YES user_id=1164639 Anyone interested in fixing this (I'm trying to find time :) might like to follow this thread on pgsql-hackers (from the PG Admin III guys, who obviously have run into the same problem between betas): http://archives.postgresql.org/pgsql-hackers/2004-11/msg00981.php ---------------------------------------------------------------------- Comment By: Robert Treat (xzilla) Date: 2004-11-26 04:02 Message: Logged In: YES user_id=204589 Notes from Chris for anyone wanting to fix this. (22:13:52) KL: you'll need to remove all the support for tablespaces on schemas tho (22:13:58) KL: ie. on create and alter schema screens (22:14:10) KL: then fix the queries for showingthe list of schemas (22:14:16) KL: and remove the tablespace col from that list ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=418980&aid=1071610&group_id=37132 |