Re: Inconsistent behavior of pg_dump/pg_restore on DEFAULT PRIVILEGES

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Neil Chen <carpenter(dot)nail(dot)cz(at)gmail(dot)com>
Cc: "Bossart, Nathan" <bossartn(at)amazon(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Michael Paquier <michael(at)paquier(dot)xyz>, "Boris P(dot) Korzun" <drtr0jan(at)yandex(dot)ru>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Inconsistent behavior of pg_dump/pg_restore on DEFAULT PRIVILEGES
Date: 2021-10-22 19:26:49
Message-ID: 2818927.1634930809@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-hackers

I wrote:
> [ pokes at it some more... ] Yeah, I just didn't have my head screwed
> on straight. We need the global entries to be dumped as deltas from
> the proper object-type-specific ACL, while the non-global ones should be
> dumped as grants only, which can be modeled as a delta from an empty
> ACL. So the patch should be good as given (though maybe the comment
> needs more work to clarify this). Sorry for the noise.

This was blocking some other work I'm doing on pg_dump, so I rewrote
the comment some more and pushed it.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Bossart, Nathan 2021-10-22 20:08:01 Re: Inconsistent behavior of pg_dump/pg_restore on DEFAULT PRIVILEGES
Previous Message Tom Lane 2021-10-22 15:27:16 Re: BUG #17244: strange string to timestamp with time zone conversion due to summer time / winter time switch ?

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2021-10-22 19:41:07 Re: Experimenting with hash tables inside pg_dump
Previous Message Mikhail 2021-10-22 19:07:14 Re: [PATCH] Make ENOSPC not fatal in semaphore creation