[MacPorts] #26472: Add extra variants to postgresql90

[MacPorts]

#26472: Add extra variants to postgresql90
-----------------------------------+----------------------------------------
 Reporter:  ddebernardy@…          |       Owner:  macports-tickets@…                   
     Type:  enhancement            |      Status:  new                                  
 Priority:  Normal                 |   Milestone:                                       
Component:  ports                  |     Version:  1.9.1                                
 Keywords:                         |        Port:  postgresql90                         
-----------------------------------+----------------------------------------

Comment(by ddebernardy@…):

 For information, I'm also running into a bug when using that contrib:

 {{{
 backend=# \i ./unaccent.sql
 SET
 CREATE FUNCTION
 CREATE FUNCTION
 CREATE FUNCTION
 CREATE FUNCTION
 CREATE TEXT SEARCH TEMPLATE
 psql:./unaccent.sql:34: WARNING:  duplicate TO argument, use first one
 CONTEXT:  line 8 of configuration file
 "/opt/local/share/postgresql90/tsearch_data/unaccent.rules": "à  a
 "
 psql:./unaccent.sql:34: WARNING:  duplicate TO argument, use first one
 CONTEXT:  line 57 of configuration file
 "/opt/local/share/postgresql90/tsearch_data/unaccent.rules": "Ġ G
 "
 psql:./unaccent.sql:34: WARNING:  duplicate TO argument, use first one
 CONTEXT:  line 144 of configuration file
 "/opt/local/share/postgresql90/tsearch_data/unaccent.rules": "Š        S
 "
 CREATE TEXT SEARCH DICTIONARY

 backend=# select unaccent('Š');
 WARNING:  duplicate TO argument, use first one
 CONTEXT:  line 8 of configuration file
 "/opt/local/share/postgresql90/tsearch_data/unaccent.rules": "à  a
 "
 WARNING:  duplicate TO argument, use first one
 CONTEXT:  line 57 of configuration file
 "/opt/local/share/postgresql90/tsearch_data/unaccent.rules": "Ġ G
 "
 WARNING:  duplicate TO argument, use first one
 CONTEXT:  line 144 of configuration file
 "/opt/local/share/postgresql90/tsearch_data/unaccent.rules": "Š        S
 "
  unaccent
 ----------
  Š
 (1 row)

 backend=# select unaccent('Š');
  unaccent
 ----------
  Š
 (1 row)
 }}}

 (the second call returns no warning, but still doesn't transform the
 string)

 To add the contrib to the port, I added a variant to the portfile:

 {{{
 variant unaccent description {add unaccent contrib module} {
         set contribs "${contribs} unaccent"
 }
 }}}

 Followed by:

 {{{
 sudo port install postgresql +perl +unaccent
 }}}

 I've reported it upstream to Marc Fournier (postgresql dev).

-- 
Ticket URL: <http://trac.macports.org/ticket/26472#comment:1>
MacPorts <http://www.macports.org/>
Ports system for Mac OS