Odoo Help


No module named psycopg2 !

on 5/23/13, 8:27 AM 3,012 views

I Have this error when i execute a onchange method :

No module named psycopg2

Here my on_change method :

def onchange_produit(self, cr, uid, ids, designation_produit, ref_produit, marque, context=None):
    if context is None:
        context = {}
        context['lang'] = self.pool.get('res.users').browse(cr,uid,uid).context_lang

    if designation_produit:
        formulprod = self.pool.get('mrp.bom').browse(cr, uid, designation_produit, context=context)
        v = {'ref_produit': formulprod.code, 'marque': formulprod.routing_id}
        return {'value': v}
    return {}

Help me plz


ClueLogics Technologies Pvt. Ltd.

--ClueLogics Technologies Pvt. Ltd.--
| 6 5 8
Delhi NCR, India
--ClueLogics Technologies Pvt. Ltd.--

 ClueLogics Technologies Pvt Ltd is a Software product and services provider. We are positioned to deliver robust, rapid and reliable Information Technology solutions that work. What we succeed upon is Technology and Technical Expertise. The industry review of ClueLogics has been commendable for the past years as most of its business comes from repeat orders by highly satisfied clients.

ClueLogics Technologies Pvt. Ltd.
On 5/23/13, 8:31 AM

hey fdlim

install psycopg2 module in python dist-package

if you are using linux then just

 sudo apt-get install python-psycopg2

from your system root:


I have a new error :

on 5/23/13, 8:50 AM

OperationalError: Unable to use the cursor after having closed it

on 5/23/13, 8:51 AM

Sudhir Arya (ERP Harbor Consulting Services)

--Sudhir Arya (ERP Harbor Consulting Services)--
| 6 8 8
Ahmedabad, India
--Sudhir Arya (ERP Harbor Consulting Services)--

• Co-Founder & Co-Owner at ERP Harbor Consulting Services

• ERP Consultant / ERP Customization / TechnoFunctional Expert

• Sound knowledge in Python, Odoo (Open ERP), XML, PostgreSQL

• Domain knowledge of Sale Management, Purchase Management, Warehouse Management, Manufacturing, Multi Company Configuration & Management, HR Management, Medical Management, Construction Management, Education Management, Point of Sale, Third Party Integrations

• Positive attitude and quick Learner

• Good analytical skill, quick bug and issue tracing and find the solution

• Good knowledge and experience in payment gateway integration with Odoo

• Ready to accept new challenges

• Active Memeber On Stackoverflow 




Sudhir Arya
ERP Harbor Consulting Services
Sudhir Arya (ERP Harbor Consulting Services)
On 5/23/13, 8:53 AM

It seems psycopg2 is not installed in your system. First install psycopg2 and then run OpenERP server.

Command to install psycopg2:

sudo apt-get install python-psycopg2


sudo easy_install psycopg2


You can download latest package (tar.gz) from Download pysycopg2. After that extract it, open terminal and run setup.py file.

sudo python setup.py install

About This Community

This platform is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.


Odoo Training Center

Access to our E-learning platform and experience all Odoo Apps through learning videos, exercises and Quizz.

Test it now

Question tools

0 follower(s)


Asked: 5/23/13, 8:27 AM
Seen: 3012 times
Last updated: 3/16/15, 8:10 AM