Odoo Help

Welcome!

This community 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.

0

Delete a custom field directly on postgres "openerp7" via command line

By
Yassine TEIMI
on 11/17/14, 9:11 AM 400 views

I'm on ubuntu server 12.04 LTS, and here is My issue : 

I deleted a custom field x_entrpt, via the configuration module, I was automatically loged out by the server.

The FACT is : the field x_entrpt still exist on the view, so it generated xml architecture error, and now I am enable to connect to my openerp erp account via web client.

The field deleted still exist on the res_users view, so now I decided to enter the res_users view, from pgsql, there is a table ir_ui_view, it contains all the views of the current database, I need to access the views table, and delete from the res_users view the field x_entrpt.

I need to know the sql query to do that. 

Is this the correct solution for this kind of problem ?

thanks.

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 11/17/14, 9:11 AM
Seen: 400 times
Last updated: 3/16/15, 8:10 AM