• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. SQL Reference
  5. DWS and Postgres SQL
  6. PostgreSQL Features Unsupported by DWS

PostgreSQL Features Unsupported by DWS

  • Tablespaces
  • Table inheritance
  • The following table creation features:
    • Create tables in ROUNDROBIN or MODULO distribution mode.
    • Use TO NODE/GROUP to specify the nodes where table data is to be distributed.
    • Use REFERENCES reftable [ (refcolumn) ] [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE action ] [ ON UPDATE action ] to create a foreign key constraint for a table.
    • Use EXCLUDE [ USING index_method ] ( exclude_element WITH operator [, ... ] ) to create exclusion constraints for a table.
  • The following table modification features:
    • Modify the distribution mode of table data.
    • The list of nodes modified for data distribution can be invoked only during scaling at the DWS background. Users or applications cannot use the list.
  • CREATE EXTENSION, ALTER EXTENSION, and DROP EXTENSION can be invoked only at the DWS background during upgrade. Users or applications cannot use them.
  • Define or change the security tag of an object.
  • Aggregate function
  • User-defined C functions
  • Create, modify, and delete operators.
  • Create, modify, and delete operator classes.
  • Create, modify, and delete operator families.
  • Create, modify, and delete types.
  • Create, modify, and delete text search dictionaries.
  • Create, modify, and delete text search parsers.
  • Create, modify, and delete text search templates.
  • Create, modify, and delete collations.
  • Create and delete rules.
  • Create, modify, and delete triggers.
  • Register, modify, and delete languages.
  • Create, modify, and delete domains.
  • Define, modify, and delete the conversion of character set encoding.
  • Define and delete type cast.
  • Define, modify, and delete foreign data wrappers.
  • Define, modify, and delete user mapping.
  • Generate a notification.
  • Listen for a notification.
  • Stop listening for a notification.
  • Load or reload a shared library file.
  • Release the session resources of a database.
  • Move a cursor backward.
The following features are disabled in DWS for separation of rights:
  • WITH GRANT OPTION and TO PUBLIC of GRANT
  • COPY FROM FILE and COPY TO FILE of COPY