search

digitalfondue / lavagna

Lavagna: issue tracker/project management tool
http://lavagna.io
GNU General Public License v3.0
635 stars 109 forks source link

Consider the existence of 'unnaccent' extension on database for Postgresql #146

Closed alinuxGit closed 3 years ago

alinuxGit commented 3 years ago

In some context for security reasons the database user could not have superuser or database owner privileges for creating the unaccent extension. This extension could be create by database admin, but at first installation the next error will be thrown:

Caused by: org.postgresql.util.PSQLException: ERROR: extension "unaccent" already exists

I think will be enough to modify the next sql statement on file V1__INITIAL_VERSION.sql

create extension if not exists unaccent;
syjer commented 3 years ago

hi @alinuxGit , thank you for opening the issue, I'll have a look if I can modify the statement as you suggested.

syjer commented 3 years ago

I've pushed the fix. After I do some updates, I will do a release. Thank you for opening the issue :)

alinuxGit commented 3 years ago

thank you @syjer I really appreciate your fix velocity. I can't wait to install the new version.