{"action":"created","issue":{"url":"https://api.github.com/repos/odoo/odoo/issues/4861","labels_url":"https://api.github.com/repos/odoo/odoo/issues/4861/labels{/name}","comments_url":"https://api.github.com/repos/odoo/odoo/issues/4861/comments","events_url":"https://api.github.com/repos/odoo/odoo/issues/4861/events","html_url":"https://github.com/odoo/odoo/pull/4861","id":55259078,"number":4861,"title":"[FIX] bad declaration of column in inherited table","user":{"login":"cecton","id":3018448,"avatar_url":"https://avatars.githubusercontent.com/u/3018448?v=3","gravatar_id":"","url":"https://api.github.com/users/cecton","html_url":"https://github.com/cecton","followers_url":"https://api.github.com/users/cecton/followers","following_url":"https://api.github.com/users/cecton/following{/other_user}","gists_url":"https://api.github.com/users/cecton/gists{/gist_id}","starred_url":"https://api.github.com/users/cecton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cecton/subscriptions","organizations_url":"https://api.github.com/users/cecton/orgs","repos_url":"https://api.github.com/users/cecton/repos","events_url":"https://api.github.com/users/cecton/events{/privacy}","received_events_url":"https://api.github.com/users/cecton/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-01-23T09:03:18Z","updated_at":"2015-01-23T15:06:15Z","closed_at":null,"pull_request":{"url":"https://api.github.com/repos/odoo/odoo/pulls/4861","html_url":"https://github.com/odoo/odoo/pull/4861","diff_url":"https://github.com/odoo/odoo/pull/4861.diff","patch_url":"https://github.com/odoo/odoo/pull/4861.patch"},"body":"Column 'name' must be required because it is required in ir.actions.actions and these tables use the PostgreSQL inheritance mechanism.\r\n\r\n*Note:* I'm still looking for a simple use-case but it's related to PostgreSQL 9.4.\r\n\r\nSome logs:\r\n> pg_restore: creating TABLE ir_act_window\r\n> pg_restore: [archiver (db)] Error while PROCESSING TOC:\r\n> pg_restore: [archiver (db)] Error from TOC entry 694; 1259 34517832 TABLE ir_act_window openerp\r\n> pg_restore: [archiver (db)] could not execute query: ERROR:  column \"name\" in child table must be marked NOT NULL\r\n>     Command was:\r\n> -- For binary upgrade, must preserve pg_type oid\r\n> SELECT binary_upgrade.set_next_pg_type_oid('34517834'::pg_catalog.oid);"},"comment":{"url":"https://api.github.com/repos/odoo/odoo/issues/comments/71205920","html_url":"https://github.com/odoo/odoo/pull/4861#issuecomment-71205920","issue_url":"https://api.github.com/repos/odoo/odoo/issues/4861","id":71205920,"user":{"login":"cecton","id":3018448,"avatar_url":"https://avatars.githubusercontent.com/u/3018448?v=3","gravatar_id":"","url":"https://api.github.com/users/cecton","html_url":"https://github.com/cecton","followers_url":"https://api.github.com/users/cecton/followers","following_url":"https://api.github.com/users/cecton/following{/other_user}","gists_url":"https://api.github.com/users/cecton/gists{/gist_id}","starred_url":"https://api.github.com/users/cecton/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/cecton/subscriptions","organizations_url":"https://api.github.com/users/cecton/orgs","repos_url":"https://api.github.com/users/cecton/repos","events_url":"https://api.github.com/users/cecton/events{/privacy}","received_events_url":"https://api.github.com/users/cecton/received_events","type":"User","site_admin":false},"created_at":"2015-01-23T15:06:15Z","updated_at":"2015-01-23T15:06:15Z","body":"@mart-e cannot reproduce! I think it happen with all version of PostgreSQL if you attempt to upgrade your cluster.\r\n\r\nBut the cause of the issue is clear and simple, I propose we merge it at least for the master but you should consider merging it in 8.0. It's safe to do because it's impossible to insert a row in ir.actions.actions where name is NULL and therefore, (I have tested on ~100 databases) it's impossible to have inconsistencies here. It's only ambiguous in the declaration and will eventually cause errors with some SQL queries."}}