Help Center> Data Warehouse Service> SQL Syntax Reference> Differences Between GaussDB(DWS) and Postgres SQL> PostgreSQL Features Unsupported by GaussDB(DWS)
View PDF

PostgreSQL Features Unsupported by GaussDB(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 GaussDB(DWS) background. Users or applications cannot use the list.
  • CREATE EXTENSION, ALTER EXTENSION, and DROP EXTENSION can be invoked only at the GaussDB(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 GaussDB(DWS) for separation of rights:
  • WITH GRANT OPTION and TO PUBLIC of GRANT
  • COPY FROM FILE and COPY TO FILE of COPY