Help Center > > Developer Guide> SQL Reference> DWS and Postgres SQL> PostgreSQL Features Unsupported by DWS

PostgreSQL Features Unsupported by DWS

Updated at: May 15, 2019 GMT+08:00
  • 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:

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?

Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel