Horton

Re: DROP OWNED BY is broken on master branch.

Robert Haas <robertmhaas@gmail.com>

View thread View on postgr.es
From: Robert Haas <robertmhaas@gmail.com>
To: Rushabh Lathia <rushabh.lathia@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2022-09-27T14:04:14Z
Lists: pgsql-hackers

Attachments

On Tue, Sep 27, 2022 at 2:53 AM Rushabh Lathia <rushabh.lathia@gmail.com> wrote:
> Yes, I was also thinking to avoid the duplicate logic but couldn't found
> a way.  I did the quick testing with the patch, and reported test is working
> fine.   But  "make check" is failing with few failures.

Oh, woops. There was a dumb mistake in that version -- it was testing
sdepForm->dbid == SHARED_DEPENDENCY_OWNER, which is nonsense, instead
of sdepForm->dbid == MyDatabaseId. Here's a fixed version.

-- 
Robert Haas
EDB: http://www.enterprisedb.com

Commits

  1. Fix bug in DROP OWNED BY.

  2. Ensure that pg_auth_members.grantor is always valid.