Hi Dave,

Role dependency test cases are failing due to database error *'ERROR: cache
lookup failed for database XXXXXX'. *Test-suite throwing error on* "DROP
ROLE <role_name>".*
This is intermittent issue I was executing test cases on all
servers (pg9.2-10 and ppas9.2-10)

Somehow the 'DROP database' didn't drop the shared dependencies correctly
in role dependency test cases.
PostgreSQL still thinks that Role owns 1 table in the database which is
dropped now .Due to that role was not able to drop.
This could be a bug in PG. Anyway, since the database is dropped, it is
safe to manually remove the user as it is not of any use more.


Please find the patch.

Thanks.

-- 
Regards,
Navnath Gadakh

EnterpriseDB Corporation
The Enterprise PostgreSQL Company

Attachment: role_dependencies_tests_modification_v1.patch
Description: Binary data

Reply via email to