Hi,
In PPAS 9.0, two new functions have been introduced to retrieve information
related to package elements. We need to incorporate the same as the old sql
query will not work anymore.
Regards,
Nikhils
diff --git a/pgadmin/schema/edbPackage.cpp b/pgadmin/schema/edbPackage.cpp
index f1cec72..d703eb1 100644
--- a/pgadmin/schema/edbPackage.cpp
+++ b/pgadmin/schema/edbPackage.cpp
@@ -224,11 +224,17 @@ pgObject *edbPackageFactory::CreateObjects(pgCollection *collection, ctlTree *br
{
edbPackage *package = 0;
- wxString sql;
+ wxString sql, pkgrestriction;
+
+ if (collection->GetConnection()->EdbMinimumVersion(9, 0))
+ pkgrestriction = wxT("pg_catalog.edb_get_packagebodydef(nsp.oid) AS pkgbodysrc, ")
+ wxT("pg_catalog.edb_get_packageheaddef(nsp.oid) AS pkgheadsrc,\n");
+ else if (collection->GetConnection()->EdbMinimumVersion(8, 2))
+ pkgrestriction = wxT("nspbodysrc AS pkgbodysrc, nspheadsrc AS pkgheadsrc,\n");
if (collection->GetConnection()->EdbMinimumVersion(8, 2))
{
- sql = wxT("SELECT nsp.oid, nsp.xmin, nspname AS pkgname, nspbodysrc AS pkgbodysrc, nspheadsrc AS pkgheadsrc,\n")
+ sql = wxT("SELECT nsp.oid, nsp.xmin, nspname AS pkgname,\n") + pkgrestriction +
wxT(" nspacl AS pkgacl, pg_get_userbyid(nspowner) AS owner, description\n")
wxT(" FROM pg_namespace nsp")
wxT(" LEFT OUTER JOIN pg_description des ON des.objoid=nsp.oid\n")
--
Sent via pgadmin-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers
