Pivotal Knowledge Base

Follow

Create table failed with "ERROR: toast table is not supported"

Problem

Tried to create a simple table but failed with "ERROR:  toast table is not supported"

hawqdb=# create table t1(a int, b text) distributed by (a);
ERROR:  toast table is not supported

Analysis

tablespace of "hawqdb" database was configured as system default table space "pg_default" which could not be used according to JIRA GPSQL-74

hawqdb=# select datname, dattablespace, dat2tablespace from pg_database;
  datname  | dattablespace | dat2tablespace
-----------+---------------+----------------
 template0 |          1663 |           1663
 template1 |          1663 |           1663
 hawqdb    |          1663 |           1663
(4 rows)

Solution

The best way will be to create another user level table space and make database to use that table space. But so far I didn't find a way to achieve that. So the workaround is to create another database with non-system table space and migrate the data to new database

Comments

Powered by Zendesk