Comment 4 for bug 939526

Revision history for this message
risto3 (risto3) wrote :

using PostgreSQL 9.1.2 here
t61=# \dx
                         List of installed extensions
   Name | Version | Schema | Description
----------+---------+------------+---------------------------------------------
 plpgsql | 1.0 | pg_catalog | PL/pgSQL procedural language
 unaccent | 1.0 | public | text search dictionary that removes accents
(2 rows)

no sign of usage now with noaccent except at opening of the db:
2012-05-24 16:24:22,027 9062 INFO ? openerp: OpenERP version 6.1-1
2012-05-24 16:24:22,027 9062 INFO ? openerp: addons paths: /usr/lib/python2.6/site-packages/openerp-6.1_1-py2.6.egg/openerp/addons
2012-05-24 16:24:22,027 9062 INFO ? openerp: database hostname: localhost
2012-05-24 16:24:22,028 9062 INFO ? openerp: database port: 5432
2012-05-24 16:24:22,028 9062 INFO ? openerp: database user: richard
2012-05-24 16:24:22,029 9062 INFO ? openerp.netsvc: Starting 0 services
2012-05-24 16:24:22,057 9062 INFO ? openerp.wsgi.core: HTTP service (werkzeug) running on 0.0.0.0:8069
2012-05-24 16:24:22,415 9062 INFO ? openerp.addons.web: embedded mode
2012-05-24 16:24:23,326 9062 INFO ? openerp: OpenERP server is running, waiting for connections...
2012-05-24 16:24:28,614 9062 DEBUG t61 openerp.sql_db: create serialized cursor to 't61'
2012-05-24 16:24:28,614 9062 DEBUG t61 openerp.sql_db: ConnectionPool(used=0/count=0/max=64) Borrow connection to 'user=richard dbname=t61'
2012-05-24 16:24:28,634 9062 DEBUG t61 openerp.sql_db: ConnectionPool(used=1/count=1/max=64) Create new connection
2012-05-24 16:24:28,639 9062 DEBUG t61 openerp.sql_db: query: SELECT proname FROM pg_proc WHERE proname='unaccent'
2012-05-24 16:24:28,640 9062 DEBUG t61 openerp.sql_db: SQL LOG from:
2012-05-24 16:24:28,640 9062 DEBUG t61 openerp.sql_db: table: pg_proc: 0:00:00.003083/1
2012-05-24 16:24:28,640 9062 DEBUG t61 openerp.sql_db: SUM from:0:00:00.003083/1 [1]
2012-05-24 16:24:28,640 9062 DEBUG t61 openerp.sql_db: SUM into:0:00:00/1 [1]
2012-05-24 16:24:28,640 9062 DEBUG t61 openerp.sql_db: ConnectionPool(used=1/count=1/max=64) Give back connection to 'user=richard dbname=t61'
2012-05-24 16:24:28,641 9062 DEBUG t61 openerp.sql_db: ConnectionPool(used=0/count=1/max=64) Put connection to 'user=richard dbname=t61' in pool
2012-05-24 16:24:28,646 9062 DEBUG t61 openerp.sql_db: create serialized cursor to 't61'

d

perhaps you could share me your test procedure (yaml?) so I could try here with something that will now **use** unaccent.