Odoo Help


ProgrammingError: ERREUR: erreur de syntaxe sur ou près de « analyse » LINE 1: COMMENT ON COLUMN analyse."name" IS 'pat'

sanaa tayb
on 5/25/13, 5:27 PM 3,502 views

Hello , plz i need your help : here is my module :


from openerp import addons 
from osv import fields, osv
import time

class analyse(osv.osv):
    _description='fiche danalyse du patient'

        'name' : fields.char('pat', size=34 ,required=True),

and here is my XML file :


<?xml version="1.0" encoding="utf-8"?>
    <record model="ir.ui.view" id="analyse_tree_view">
        <field name="name">analyse.tree</field>
        <field name="model">analyse</field>
        <field name="type">tree</field>
        <field name="arch" type="xml">
            <tree string="Analyse" version="7.0">
                <field name="name" />

    <record model="ir.ui.view" id="analyse_form_view">
        <field name="name">analyse.form</field>
        <field name="model">analyse</field>
        <field name="type">form</field>
        <field name="arch" type="xml">
            <form string="Analyse" version="7.0">
                <group colspan="4" col="4" string=" Fiche d'analyse">
                    <field name="name" />

    <record model="ir.actions.act_window" id="analyse_form_1">
        <field name="name">analyse</field>
        <field name="res_model">analyse</field>
        <field name="view_type">form</field>
        <field name="view_mode">tree,form</field>

    <menuitem id="analys" name="Analyse"  parent="menu_patients_parent1" action="analyse_form_1" sequence="3"/>

PS: menu_patients_parent1 , refers to a parents created in another .XML file , befor i added the analyse.py and analyse.XML the module worked just fine , but now while installing i get the following error :

ProgrammingError: ERREUR: erreur de syntaxe sur ou près de « analyse » LINE 1: COMMENT ON COLUMN analyse."name" IS 'pat'

On 5/26/13, 12:10 PM


ERROR: syntax error at or near "analyse"

analyse is a reserved keyword in in Postgresql. that's why you have encountered some problem.

so to resolved this problem change _name='analyse' to other name for example _name='my_analyse'.


thank you very much it Did work :)

sanaa tayb
on 5/26/13, 3:55 PM

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

1 follower(s)


Asked: 5/25/13, 5:27 PM
Seen: 3502 times
Last updated: 3/16/15, 8:10 AM