pgadmin4 icon indicating copy to clipboard operation
pgadmin4 copied to clipboard

Schema Diff does not find differences on 'GRANT USAGE ON SCHEMA'

Open fjf2002 opened this issue 1 year ago • 0 comments

Describe the bug

Schema Diff does not find differences on 'GRANT USAGE ON SCHEMA'.

To Reproduce Given a user myuser,

  1. On the first database, execute:
CREATE SCHEMA foo;
GRANT USAGE ON SCHEMA foo TO myuser;
  1. On the second database, execute:
CREATE SCHEMA foo;
  1. Perform a schema diff.

Expected behavior The obvious difference should be listed:

GRANT USAGE ON SCHEMA foo TO myuser;

But it won't. No differences are shown.

Error message None.

Desktop (please complete the following information):

  • Postgres Docker Container 16.3
  • pgadmin Docker Container 8.6

fjf2002 avatar May 15 '24 15:05 fjf2002