Re: 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, Suporte 24x7 e Treinamento

... ok
No alternatives for unaccent on 8.4?

2011/9/21 Euler Taveira de Oliveira <euler(at)timbira(dot)com>

> 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, Suporte 24x7 e Treinamento
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-hackers<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(dot)vazquez(at)bull(dot)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, Suporte 24x7 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(at)timbira(dot)com> writes:
> On 21-09-2011 13:28, Daniel Vzquez 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

2011/9/21 Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>

> Euler Taveira de Oliveira <euler(at)timbira(dot)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
>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)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(dot)vazquez(at)bull(dot)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, Suporte 24x7 e Treinamento

2011/9/22 Daniel Vázquez <daniel2d2art(at)gmail(dot)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(at)timbira(dot)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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83