[YSQL] Feature Support - CREATE TABLE

[nocaway]

Jira Link: DB-1307
The following features and options are not yet supported in CREATE TABLE command.

• TABLESPACE ([YSQL] Feature Support - TABLESPACE #1153)
• UNLOGGED
• INHERITS
• LIKE ([YSQL] Support LIKE clause #12791)
• PARTITION BY ([YSQL] Feature Support - PARTITIONING #1126)
• Constraints: UNIQUE ([YSQL] Implement UNIQUE constraint #1022), GENERATED ([YSQL] Add support for identity column #1267), REFERENCES, EXCLUDE([YSQL] CREATE TABLE optional constraints #997), FOREIGN KEY([YSQL] CREATE TABLE optional constraints #997)
• WITH clause ([YSQL] accept and ignore "with storage parameters" for create table statements  #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 ( #870 , de50449 ) -- 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?

[p-null]

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

[savex83]

I'm on Django 3.1.7 and I get:
Applying auth.0008_alter_user_username_max_length...Traceback (most recent call last):
File "/Users/save/.virtualenvs/esadash/lib/python3.8/site-packages/django/db/backends/utils.py", line 84, in _execute
return self.cursor.execute(sql, params)
psycopg2.errors.FeatureNotSupported: TABLESPACE not supported yet
HINT: See #1129. Click '+' on the description to raise its priority

I'm thinking to move from Postgresql to YugabyteDB, but right now seems to be very difficult.
Thank you for your work, guys.