Hi,
Please find the attached patch to fix the RM 2173: Sequences API test cases
are not working in PG9.2 and PPAS9.2
The query which fetches the privileges was not compatible with Postgres 9.2.
So, To fix this issue I have changed the query little bit.
Dave/Ashesh,
Please review my query change and let me know if I have done anything wrong.
Thanks,
Khushboo
diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/templates/sequence/sql/default/acl.sql b/web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/templates/sequence/sql/default/acl.sql
index ea996c9..0a78a1c 100644
--- a/web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/templates/sequence/sql/default/acl.sql
+++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/sequences/templates/sequence/sql/default/acl.sql
@@ -18,12 +18,11 @@ FROM
ELSE 'UNKNOWN'
END AS privilege_type
FROM
- (SELECT relacl
+ aclexplode((SELECT relacl
FROM pg_class cl
LEFT OUTER JOIN pg_description des ON (des.objoid=cl.oid AND des.classoid='pg_class'::regclass)
WHERE relkind = 'S' AND relnamespace = {{scid}}::oid
- AND cl.oid = {{seid}}::oid ) acl,
- aclexplode(relacl) d
+ AND cl.oid = {{seid}}::oid )) d
) d
LEFT JOIN pg_catalog.pg_roles g ON (d.grantor = g.oid)
LEFT JOIN pg_catalog.pg_roles gt ON (d.grantee = gt.oid)
--
Sent via pgadmin-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-hackers
