Fully define a new table before using it
The current release of Regatta does not supportALTER TABLE
operations after the table has been created. It is still possible to split the table creation into multiple statements if the first statement contains the SET NOT READY
clause:
ALTER TABLE
statements with this table. For example:
SET READY
command. That command declares that the table is fully defined and available for use.
Index on a single column only
The current release of Regatta supports indexes only on a single column. In the case that a combination of columns needs to be indexed, a compound field may be created and maintained, with the index on the compound field.PRIMARY KEY INDEX
Note that in the current release, Regatta requires the keywordINDEX
after the constraint PRIMARY KEY
.