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

The encryption_package cannot be updated without uninstalling it first #56

Open
nicolasriousset opened this issue Feb 15, 2018 · 0 comments

Comments

@nicolasriousset
Copy link

The encryption_package cannot be updated without uninstalling it first.

When executing
make install
while the library is already installed, the following error are displayed

vsql:ddl/install.sql:5: ROLLBACK 4213: Object "Encryption" already exists
vsql:ddl/install.sql:6: ROLLBACK 3472: Function with same name and number of parameters already exists: AESEncrypt
vsql:ddl/install.sql:7: ROLLBACK 3472: Function with same name and number of parameters already exists: AESDecrypt

This is really problematic when the functions are used in a Vertica column default expression, because as soon as the library is dropped, the whole table using the default expression is lost.

Replacing the "CREATE" statements with a "CREATE OR REPLACE" solves the issue.

nicolasriousset added a commit to nicolasriousset/Vertica-Extension-Packages that referenced this issue Feb 15, 2018
…ling it first

vertica#56 The encryption_package can now be updated without uninstalling it first.
nicolasriousset added a commit to nicolasriousset/Vertica-Extension-Packages that referenced this issue Feb 15, 2018
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant