pgAdmin4: Cleanup in role dependency test cases

From: Navnath Gadakh <navnath(dot)gadakh(at)enterprisedb(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Cc: Kanchan Mohitey <kanchan(dot)mohitey(at)enterprisedb(dot)com>
Subject: pgAdmin4: Cleanup in role dependency test cases
Date: 2017-08-30 05:34:56
Message-ID: CAOAJCYpAQez=7SUOGSmhbX6kGux5g-7S0p4YiMZq6ym9L37Nnw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

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 Content-Type Size
role_dependencies_tests_modification_v1.patch application/octet-stream 3.0 KB

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Murtuza Zabuawala 2017-08-30 05:49:07 Re: [pgAdmin4][Patch]: Allow user to provide custom SSL certificates and provide .pgpass file
Previous Message Dave Page 2017-08-29 15:09:15 Re: [pgaweb][patch] Use https link for git repo