Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

liquibase dropAll error drop pg_stat_statements #1451

Open
tillias opened this issue Oct 2, 2020 · 1 comment
Open

liquibase dropAll error drop pg_stat_statements #1451

tillias opened this issue Oct 2, 2020 · 1 comment
Labels
commandDropAll DBPostgres hacktoberfest a month-long celebration of open-source software and Developers contribute by completing PRs ImpactMedium IntegrationMaven Severity3 TypeEnhancement ver3.9.0

Comments

@tillias
Copy link

tillias commented Oct 2, 2020

Environment

Liquibase Version:
3.9.0

Liquibase Integration & Version: <Pick one: CLI, maven, gradle, spring boot, servlet, etc.>
liquibase-maven-plugin:3.9.0

Liquibase Extension(s) & Version:

Database Vendor & Version:
PostgreSQL 11.5 (Ubuntu 11.5-3.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit provided by elephantsql.com

Operating System Type & Version:
PostgreSQL 11.5 (Ubuntu 11.5-3.pgdg18.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit provided by elephantsql.com

Description

When executing liquibase:dropAll following error is shown:

ERROR: must be owner of view pg_stat_statements [Failed SQL: (0) DROP VIEW "pg_stat_statements"]

Steps To Reproduce

Create test account on elephantsql.com
Deploy anything with liquibase
Issue liquibase:dropAll (either CLI or maven plugin)

Actual Behavior

Error is shown

Expected/Desired Behavior

pg_stat_statements is not touched, cause there are no permissions for it

@tillias
Copy link
Author

tillias commented Oct 2, 2020

Please note that there may be other objects after pg_stat_statements. Is there any possibility to exclude pg_stat_statements for dropAll?

@ro-rah ro-rah added the hacktoberfest a month-long celebration of open-source software and Developers contribute by completing PRs label Oct 6, 2020
@MalloD12 MalloD12 self-assigned this Aug 12, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
commandDropAll DBPostgres hacktoberfest a month-long celebration of open-source software and Developers contribute by completing PRs ImpactMedium IntegrationMaven Severity3 TypeEnhancement ver3.9.0
Projects
Development

No branches or pull requests

5 participants