[YSQL] CREATE DATABASE ... TABLESPACE ...; not supported

[radekg]

Jira Link: DB-4791
I'm using a version 2.7.2 and I have the following:

yugabyte=# create tablespace space_tenant1
yugabyte-#   with (replica_placement='{"num_replicas": 3, "placement_blocks": [
yugabyte'#     {"cloud":"dsh","region":"tenant1","zone":"tenant1a", "min_num_replicas":1},
yugabyte'#     {"cloud":"dsh","region":"tenant1","zone":"tenant1b", "min_num_replicas":1},
yugabyte'#     {"cloud":"dsh","region":"tenant1","zone":"tenant1c", "min_num_replicas":1}]}');
CREATE TABLESPACE

yugabyte=# create table aaa (rowid int) tablespace space_tenant1;
CREATE TABLE

but

yugabyte=# create database tenant1db OWNER tenant1 TABLESPACE space_tenant1;
ERROR:  Value other than default for tablespace option is not yet supported
LINE 1: create database tenant1db OWNER tenant1 TABLESPACE space_ten...
                                                ^
HINT:  Please report the issue on https://github.com/YugaByte/yugabyte-db/issues

My question is: should this be supported and it's an omission from enabling the tablespaces feature or is there a reason why this option is explicitly not supported?

[ddorian]

An alternative for now is using ALTER DATABASE set default_tablespace='' https://yugabytedb.tips/?p=3537