Error cloning permission - type "perm_type" does not exist about pg-clone-schema

[MichaelDBA]

I have integrated the user types into clone_schema, so no additional extension or types need to be added.

[MichaelDBA]

If you install pg_permissions extension (https://github.com/cybertec-postgresql/pg_permission), that will fix it. In the meantime, I am working on using SQL to get permissions without the usage of that extension.

I have updated the README for this project with instructions on how to install pg_permissions extension.

[EspadaV8]

Ah, thanks. Unfortunately we're using AWS RDS so we won't be able to install that extension. For now I think we can just remove the permission parts (they weren't in the function before so I don't think we'll miss them 😄)

[MichaelDBA]

OK, I will make it a priority to get this fixed, probably today, since this is a showstopper for RDS.

[MichaelDBA]

Just create these 2 TYPE definitions and then it should work:

CREATE TYPE perm_type AS ENUM (
   'SELECT',
   'INSERT',
   'UPDATE',
   'DELETE',
   'TRUNCATE',
   'REFERENCES',
   'TRIGGER',
   'USAGE',
   'CREATE',
   'EXECUTE',
   'CONNECT',
   'TEMPORARY'
);

CREATE TYPE obj_type AS ENUM (
   'TABLE',
   'VIEW',
   'COLUMN',
   'SEQUENCE',
   'FUNCTION',
   'SCHEMA',
   'DATABASE'
);

[EspadaV8]

Great, thank you 🙂

[denishpatel]

thanks @MichaelDBA !