Issue migrated from Redmine: https://redmine.postgresql.org/issues/7631
Originally created by Pocin Pocin at 2022-08-21 16:41:32 UTC.

# create database source;
# create database target;
# create role bob;
# \c source
source# create table foo(id text, amount text);
source# grant select, insert(id, amount), update(amount) on foo to bob;

source# \c target
target# create table foo(id text, amount text);
target# grant select, insert(id, amount), update(id, amount) on foo to bob;

the difference is the @update@ on @target.public.foo.amount.id@

the diff is empty but i would expect something along the lines of

GRANT INSERT(id), UPDATE(id) on foo to bob;

Or is the safe thing to do here REVOKE ALL on foo from bob; and apply the GRANTS from the target?