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 (as well as in Greenplum).

NOTE

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

SQL command

ALTER SYSTEM

ALTER TRIGGER

COMMIT PREPARED

CREATE CONSTRAINT TRIGGER

CREATE TRIGGER

DROP OWNED

DROP TRIGGER

LATERAL JOIN type

PREPARE TRANSACTION

ROLLBACK PREPARED

SET CONSTRAINTS

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