User Activity

  • Posted a comment on ticket #52 on BiblioteQ

    Hi. Thanks for doing this (and so quickly).... I forgot to mention this, but for postgresql to use the unaccent() extension it will need the extension to be "created". In other words, the postgresql_create_schema.sql and postgresql_update_schema.sql files in SQL will need to have the following line added: CREATE EXTENSION unaccent; https://community.webfaction.com/questions/18626/installing-extensions-like-unaccent-in-private-postgres-instance I just (briefly) went through the latest commits and...

  • Posted a comment on ticket #52 on BiblioteQ

    my previous post is still "awaiting moderation", so i'll mention it again (in case it went to a black hole)... we're going to need to add "create extension unaccent;" in postgresql_create/update files... I read the section in the pdf file, but if i was clueless (as i was when i started looking into this stuff) there would still be a fair amount of running around to do.... What do you think? Are there any advantages to not adding that ('create extension unaccent;') to create/update.sql and making...

  • Posted a comment on ticket #52 on BiblioteQ

    Oh and... (sorry) another note to be added to the release notes: I'm pretty sure (it's been a while) that after updating the unaccent.rules file they will have to restart postgresql.

  • Posted a comment on ticket #52 on BiblioteQ

    Great! Thanks! You might want to add a release note (once this is implemented) telling Greek-language users that they need to supplement their unaccent.rules file from here: https://gist.github.com/marinoszak/7d5d6a8670faae0f4589c2da988f2ba3 As in: $ curl -O https://gist.githubusercontent.com/marinoszak/7d5d6a8670faae0f4589c2da988f2ba3/raw/ee7fc798e3ce4de5b91b2b9351a3a3022a953320/unaccent.rules TSEARCH=/usr/share/postgresql/tsearch_data cp $TSEARCH/unaccent.rules $TSEARCH/unaccent.rules- && cp unaccent.rules...

  • Created ticket #52 on BiblioteQ

    use unaccent() extension in postgresql queries

  • Created ticket #51 on BiblioteQ

    use ILIKE instead of LIKE in SQL queries

View All

Personal Data

Username:
ozgurcan
Joined:
2000-08-31 00:13:00

Projects

  • No projects to display.

Personal Tools

MongoDB Logo MongoDB