Thread: unaccent contrib
Hi guys!
I know Postgresql 9.x includes "unaccent" contrib on their deliver package.
"unaccent" is compatible with postgresql 8.4 (but not is in their contrib version distribution)
what's better way to setup "unaccent" module on Postgresql 8.4 production server.
Copy contrib/unaccent from 9.x to the 8.4 installation and execute it???
We can do it???
Other ideas??
Can Global Development Group, make some acumulative rpm for contrib modules that are backward compatible???
thx!
On 21-09-2011 13:28, Daniel Vázquez wrote: > "unaccent" is compatible with postgresql 8.4 (but not is in their contrib > version distribution) > No, it is not. AFAICS it is necessary to add some backend code that is not in 8.4. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte24x7 e Treinamento
... ok
No alternatives for unaccent on 8.4?
--
Daniel Vázquez
SICONET (A Bull Group Company)
Torre Agbar. Avda. Diagonal, 211 - planta 23
08018 - Barcelona
telf: + 34 93 2272727 (Ext. 2952)
fax: + 34 93 2272728
www.bull.es - www.siconet.es
daniel.vazquez@bull.es
2011/9/21 Euler Taveira de Oliveira <euler@timbira.com>
On 21-09-2011 13:28, Daniel Vázquez wrote:No, it is not. AFAICS it is necessary to add some backend code that is not in 8.4."unaccent" is compatible with postgresql 8.4 (but not is in their contrib
version distribution)
--
Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/
PostgreSQL: Consultoria, Desenvolvimento, Suporte 24x7 e Treinamento
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Daniel Vázquez
SICONET (A Bull Group Company)
Torre Agbar. Avda. Diagonal, 211 - planta 23
08018 - Barcelona
telf: + 34 93 2272727 (Ext. 2952)
fax: + 34 93 2272728
www.bull.es - www.siconet.es
daniel.vazquez@bull.es
On 21-09-2011 15:23, Daniel Vázquez wrote: > No alternatives for unaccent on 8.4? > Not that I know of. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte24x7 e Treinamento
On Wed, 2011-09-21 at 18:28 +0200, Daniel Vázquez wrote: > Can Global Development Group, make some acumulative rpm for contrib > modules that are backward compatible??? No (as the RPM maintainer). -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Euler Taveira de Oliveira <euler@timbira.com> writes: > On 21-09-2011 13:28, Daniel V�zquez wrote: >> "unaccent" is compatible with postgresql 8.4 (but not is in their contrib >> version distribution) > No, it is not. AFAICS it is necessary to add some backend code that is not in 8.4. [ pokes at it ] Yeah, you are right. The version of unaccent that is in our source tree is a filtering dictionary, and therefore cannot possibly work with backends older than 9.0 (when the filtering dictionary feature was added). So I'm wondering where the OP read that it was compatible with 8.4. Our own documentation about it certainly does not say that. It's possible that Oleg and Teodor had some prototype version, different from what got committed to our tree, that would work in 8.4. regards, tom lane
Before 9.x, how do unaccent full text searches ?
i
--
Daniel Vázquez
SICONET (A Bull Group Company)
Torre Agbar. Avda. Diagonal, 211 - planta 23
08018 - Barcelona
telf: + 34 93 2272727 (Ext. 2952)
fax: + 34 93 2272728
www.bull.es - www.siconet.es
daniel.vazquez@bull.es
2011/9/21 Tom Lane <tgl@sss.pgh.pa.us>
Euler Taveira de Oliveira <euler@timbira.com> writes:[ pokes at it ] Yeah, you are right. The version of unaccent that is
> On 21-09-2011 13:28, Daniel Vázquez wrote:
>> "unaccent" is compatible with postgresql 8.4 (but not is in their contrib
>> version distribution)
> No, it is not. AFAICS it is necessary to add some backend code that is not in 8.4.
in our source tree is a filtering dictionary, and therefore cannot
possibly work with backends older than 9.0 (when the filtering
dictionary feature was added).
So I'm wondering where the OP read that it was compatible with 8.4.
Our own documentation about it certainly does not say that. It's
possible that Oleg and Teodor had some prototype version, different
from what got committed to our tree, that would work in 8.4.
regards, tom lane
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
Daniel Vázquez
SICONET (A Bull Group Company)
Torre Agbar. Avda. Diagonal, 211 - planta 23
08018 - Barcelona
telf: + 34 93 2272727 (Ext. 2952)
fax: + 34 93 2272728
www.bull.es - www.siconet.es
daniel.vazquez@bull.es
On 22-09-2011 12:39, Daniel Vázquez wrote: > Before 9.x, how do unaccent full text searches ? > Perform pre-processing (normalization) of the string *before* inserting and *before* searching. -- Euler Taveira de Oliveira - Timbira http://www.timbira.com.br/ PostgreSQL: Consultoria, Desenvolvimento, Suporte24x7 e Treinamento
2011/9/22 Daniel Vázquez <daniel2d2art@gmail.com>: > Before 9.x, how do unaccent full text searches ? It seems that Oleg has published something on his web site that supposedly works with 8.4: http://www.sai.msu.su/~megera/wiki/unaccent But I'm not really sure how it works, or even where the source code is. I would suggest that you Google "postgresql 8.4 unaccent" or something like that and click through the results. Also, this mailing list is for discussions of PostgreSQL development, so I think this discussion is quite a bit off-topic. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company
On Wed, 21 Sep 2011, Tom Lane wrote: > Euler Taveira de Oliveira <euler@timbira.com> writes: >> On 21-09-2011 13:28, Daniel VАzquez wrote: >>> "unaccent" is compatible with postgresql 8.4 (but not is in their contrib >>> version distribution) > >> No, it is not. AFAICS it is necessary to add some backend code that is not in 8.4. > > [ pokes at it ] Yeah, you are right. The version of unaccent that is > in our source tree is a filtering dictionary, and therefore cannot > possibly work with backends older than 9.0 (when the filtering > dictionary feature was added). > > So I'm wondering where the OP read that it was compatible with 8.4. > Our own documentation about it certainly does not say that. It's > possible that Oleg and Teodor had some prototype version, different > from what got committed to our tree, that would work in 8.4. AFAIR, the last version without filtering feature is http://www.sigaev.ru/misc/unaccent-0.2.tar.gz Regards, Oleg _____________________________________________________________ Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru), Sternberg Astronomical Institute, Moscow University, Russia Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83