Comment 2 for bug 1185431

Revision history for this message
Juan Jose Huelga (jjhuelga) wrote :

Hello Daniel, I've found this but searching a way to read and write data from/to an existing table using an OpenERP module. I would like to keep my existing tables (tables from other systems) in a different schema (one schema for every system). I haven't find a way to tell OpenERP in what squema my tables are.

The only way I've found was: I've created a new module for reading or writing to one of my tables, in my new module's model class I have set _name attr to my table name without schema's name and also set _auto to False to avoid automatic ORM table creation. Finally I went to PQSL and modified user's search_path var including my new schema. OpenERP is able to find my external table for reading and writing but now it is not writing values for create_uid, create_date, write_date and write_uid fields.