Skip to content

Instantly share code, notes, and snippets.

@tremes
Created May 20, 2019 14:30
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save tremes/55c20121fc59e35e77886a9540abfe43 to your computer and use it in GitHub Desktop.
Save tremes/55c20121fc59e35e77886a9540abfe43 to your computer and use it in GitHub Desktop.
```SET
SET
SET
SET
SET
set_config
------------
(1 row)
SET
SET
SET
SET
DROP EXTENSION
psql:/tmp/enmasse.amqonline-timestamp.pg_dump:20: ERROR: cannot drop schema public because other objects depend on it
DETAIL: table public.databasechangeloglock depends on schema public
table public.databasechangelog depends on schema public
table public.client_default_roles depends on schema public
table public.client depends on schema public
table public.client_session depends on schema public
table public.client_session_role depends on schema public
table public.composite_role depends on schema public
table public.credential depends on schema public
table public.event_entity depends on schema public
table public.keycloak_role depends on schema public
table public.realm depends on schema public
table public.realm_attribute depends on schema public
table public.realm_default_roles depends on schema public
table public.realm_events_listeners depends on schema public
table public.realm_required_credential depends on schema public
table public.realm_smtp_config depends on schema public
table public.redirect_uris depends on schema public
table public.scope_mapping depends on schema public
table public.username_login_failure depends on schema public
table public.user_attribute depends on schema public
table public.user_entity depends on schema public
table public.user_federation_config depends on schema public
table public.user_federation_provider depends on schema public
table public.user_required_action depends on schema public
table public.user_role_mapping depends on schema public
table public.user_session depends on schema public
table public.web_origins depends on schema public
table public.client_attributes depends on schema public
table public.client_session_note depends on schema public
table public.client_node_registrations depends on schema public
table public.protocol_mapper depends on schema public
table public.protocol_mapper_config depends on schema public
table public.federated_identity depends on schema public
table public.identity_provider depends on schema public
table public.identity_provider_config depends on schema public
table public.realm_supported_locales depends on schema public
table public.user_session_note depends on schema public
table public.realm_enabled_event_types depends on schema public
table public.migration_model depends on schema public
table public.identity_provider_mapper depends on schema public
table public.idp_mapper_config depends on schema public
table public.user_consent depends on schema public
table public.client_session_prot_mapper depends on schema public
table public.admin_event_entity depends on schema public
table public.authenticator_config depends on schema public
table public.authentication_flow depends on schema public
table public.authentication_execution depends on schema public
table public.authenticator_config_entry depends on schema public
table public.user_federation_mapper depends on schema public
table public.user_federation_mapper_config depends on schema public
table public.client_session_auth_status depends on schema public
table public.client_user_session_note depends on schema public
table public.required_action_provider depends on schema public
table public.required_action_config depends on schema public
table public.offline_user_session depends on schema public
table public.offline_client_session depends on schema public
table public.keycloak_group depends on schema public
table public.group_role_mapping depends on schema public
table public.group_attribute depends on schema public
table public.user_group_membership depends on schema public
table public.realm_default_groups depends on schema public
table public.client_scope depends on schema public
table public.client_scope_attributes depends on schema public
table public.client_scope_role_mapping depends on schema public
table public.resource_server depends on schema public
table public.resource_server_resource depends on schema public
table public.resource_server_scope depends on schema public
table public.resource_server_policy depends on schema public
table public.policy_config depends on schema public
table public.resource_scope depends on schema public
table public.resource_policy depends on schema public
table public.scope_policy depends on schema public
table public.associated_policy depends on schema public
table public.broker_link depends on schema public
table public.fed_user_attribute depends on schema public
table public.fed_user_consent depends on schema public
table public.fed_user_credential depends on schema public
table public.fed_user_group_membership depends on schema public
table public.fed_user_required_action depends on schema public
table public.fed_user_role_mapping depends on schema public
table public.component_config depends on schema public
table public.component depends on schema public
table public.credential_attribute depends on schema public
table public.fed_credential_attribute depends on schema public
table public.federated_user depends on schema public
table public.client_initial_access depends on schema public
table public.client_auth_flow_bindings depends on schema public
table public.client_scope_client depends on schema public
table public.default_client_scope depends on schema public
table public.user_consent_client_scope depends on schema public
table public.fed_user_consent_cl_scope depends on schema public
table public.resource_server_perm_ticket depends on schema public
table public.resource_attribute depends on schema public
table public.resource_uris depends on schema public
table public.role_attribute depends on schema public
HINT: Use DROP ... CASCADE to drop the dependent objects too.
COMMENT
psql:/tmp/enmasse.amqonline-timestamp.pg_dump:32: ERROR: schema "public" already exists
ALTER SCHEMA
COMMENT
CREATE EXTENSION
COMMENT
GRANT```
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment