Yugabyte-db: [YSQL] Feature Support - CREATE TABLE

[nocaway]

The following features and options are not yet supported in CREATE TABLE command.

• TABLESPACE (#1153)
• UNLOGGED
• INHERITS
• LIKE
• PARTITION BY (#1126)
• Constraints: UNIQUE (#1022), GENERATED (#1267), REFERENCES, EXCLUDE(#997), FOREIGN KEY(#997)
• WITH clause (#870)
• CHECK NO INHERIT

[louissheng]

Encounter WITH clause not supported error when running pg_bench.
[root@yb-tserver-0 yugabyte]# pgbench -i -c 10 -p 5433 -d postgres -h yb-tserver-0.yb-tservers.yb-9115-ysql.svc.sv-gcdb.edge.equinix.com -U postgres NOTICE: table "pgbench_branches" does not exist, skipping ERROR: WITH clause not supported yet LINE 1: ...es(bid int not null,bbalance int,filler char(88)) with (fill... ^ HINT: See https://github.com/YugaByte/yugabyte-db/issues/1129. Click '+' on the description to raise its priority

[mbautin]

@louissheng: thank you for reporting this. The WITH support got committed recently ( https://github.com/YugaByte/yugabyte-db/issues/870 , https://github.com/YugaByte/yugabyte-db/commit/de50449611d1f16189e9578d346a9a641460e118 ) -- we should be able to publish a new build including that commit in the next couple of days.

[obeleh]

django.db.utils.NotSupportedError: DEFERRABLE constraint not supported yet
LINE 1: ...type_id") REFERENCES "django_content_type" ("id") DEFERRABLE...
                                                             ^
HINT:  See https://github.com/YugaByte/yugabyte-db/issues/1129. Click '+' on the description to raise its priority

[rkarthik007]

django.db.utils.NotSupportedError: DEFERRABLE constraint not supported yet
LINE 1: ...type_id") REFERENCES "django_content_type" ("id") DEFERRABLE...
                                                             ^
HINT:  See https://github.com/YugaByte/yugabyte-db/issues/1129. Click '+' on the description to raise its priority

Hi @obeleh,

Could you also add which version you tried?

cc @m-iancu @ndeodhar

[obeleh]

I've used the helm chart. But running this command gives me:

[root@yb-master-0 yugabyte]# /home/yugabyte/bin/yb-master --version
version 2.0.5.2 build 3 revision 67110c85a716c6c642aaf4adea1797544c69544f build_type RELEASE built at 16 Nov 2019 18:41:52 UTC

Is there a newer helm chart I can try? Perhaps in the incubator repo?

[ndeodhar]

Hi @obeleh , we don't support DEFERRABLE constraints yet and plan to add support for it in Feb/March timeframe. Is there a way for you to work around without using the DEFERRABLE constraint?

[obeleh]

I was trying to see if Django would work with Yugagbyte. The command that failed was when I was trying to initialize the migrations. So at the moment I think it's best I use Postgres.

[keeganmccallum]

Same issue with DEFERRABLE here, breaks Django support, attempting to use as the postgres db with https://github.com/getsentry/sentry FYI

[wolrd]

@ndeodhar ?

I have the same problem:
"Hi @obeleh , we don't support DEFERRABLE constraints yet and plan to add support for it in Feb/March timeframe. Is there a way for you to work around without using the DEFERRABLE constraint?"

Now March and I want to start a new project on Django.
Tell me, when will the correction be?

[tingkai-zhang]

Hi, thanks for opening up this issue and working on these features. I was wondering if there is a separate issue for tracking INHERITS and a potential timeline for this feature? Thank you.

[agaldemas]

Trying with odoo to create an empty database :
got error from psycopg2 : NotSupportedError: INHERITS not supported yet

ERROR: INHERITS not supported yet
app_1         | LINE 9: CREATE TABLE ir_act_window (primary key(id)) INHERITS (ir_actions);

could be nice to add support of INHERITS for CREATE/ALTER TABLE