search

yugabyte / yugabyte-db

YugabyteDB - the cloud native distributed SQL database for mission-critical applications.
https://www.yugabyte.com
Other
8.69k stars 1.04k forks source link

CREATE TABLE () INHERITS not supported #5956

Open Tedezed opened 3 years ago

Tedezed commented 3 years ago

Jira Link: DB-1496 Hi! I am trying to use Odoo with YugabyteDB, I thought it would be interesting to reflect in this issue the related problems with this application. 

ERROR: INHERITS not supported yet
LINE 9: CREATE TABLE ir_act_window (primary key(id)) INHERITS (ir_ac...
                                                     ^
XXX-XX-XX XX ERROR None odoo.service.db: CREATE DATABASE failed: 
Traceback (most recent call last):
  File "/usr/local/lib/python3.8/dist-packages/odoo-13.0-py3.8.egg/odoo/service/db.py", line 58, in _initialize_db
    odoo.modules.db.initialize(cr)
  File "/usr/local/lib/python3.8/dist-packages/odoo-13.0-py3.8.egg/odoo/modules/db.py", line 32, in initialize
    cr.execute(base_sql_file.read())
  File "/usr/local/lib/python3.8/dist-packages/odoo-13.0-py3.8.egg/odoo/sql_db.py", line 164, in wrapper
    return f(self, *args, **kwargs)
  File "/usr/local/lib/python3.8/dist-packages/odoo-13.0-py3.8.egg/odoo/sql_db.py", line 241, in execute
    res = self._obj.execute(query, params)
psycopg2.errors.FeatureNotSupported: INHERITS not supported yet
LINE 9: CREATE TABLE ir_act_window (primary key(id)) INHERITS (ir_ac...

Related

Regards! 🍀

damendieta commented 3 years ago

Hi, Any updates about INHERITS support?

agaldemas commented 2 years ago

Hello same question, Any updates about INHERITS support ?

bosskopp commented 2 years ago

I'm an official Odoo partner who'd also be interested in that feature :smiley: Ping me if you need someone checking Odoo compatibility from time to time.

martinfar commented 1 year ago

Hi, any news ? We are needing it

jflaflamme commented 1 year ago

same here :)

agaldemas commented 6 months ago

Hello, any news about fixing this ?

agaldemas commented 2 months ago

Hello @devansh-ism, thanks for the update about INHERITS support,

I don't know well about the process of release, when a commit is pushed, and how to check about your commit integration... is your commit already in 2.20.3.1, from which I received a mail about release, then I can take this version on Dockerhub, or may I take the latest tag ? Thanks in advance for your kind answer

devansh-ism commented 2 months ago

Hi @agaldemas , I think you misunderstood the context in which I mentioned this issue. I mentioned the GH in commit summary because I commented some query in PG upstream ported regression test that uses inherits. We did this change to make test YugaByteDB compatible. Inherits is still not supported in YugabyteDB.

I'm sorry for misunderstanding caused.

agaldemas commented 2 months ago

Hi @agaldemas , I think you misunderstood the context in which I mentioned this issue. I mentioned the GH in commit summary because I commented some query in PG upstream ported regression test that uses inherits. We did this change to make test YugaByteDB compatible. Inherits is still not supported in YugabyteDB.

I'm sorry for misunderstanding caused.

That's why I ask for some details about your comment ;O)... I was trying to dive in your backlog to find out, but better to ask to people who knows... Any idea of when INHERITS support in CREATE TABLE can be testable with Odoo ? I'm really eager to ! Thanks by advance