SQL commands not supported in ADB

Daria Barysheva

Though Arenadata DB is based on PostgreSQL, some SQL commands and operators are not supported in ADB. This is due to the features of distributed databases. Below is a list of SQL commands that are currently missing in ADB.

NOTE
For more information on all SQL commands (including supported ones), see the Greenplum documentation.
SQL command

ALTER SYSTEM

ALTER TRIGGER

ALTER PUBLICATION

ALTER SUBSCRIPTION

COMMIT PREPARED

CREATE CONSTRAINT TRIGGER

CREATE PUBLICATION

CREATE SUBSCRIPTION

CREATE TRIGGER

DROP OWNED

DROP PUBLICATION

DROP SUBSCRIPTION

DROP TRIGGER

LATERAL JOIN type

PREPARE TRANSACTION

ROLLBACK PREPARED

SET CONSTRAINTS
Found a mistake? Seleсt text and press Ctrl+Enter to report it