Updated on 2024-09-30 GMT+08:00

PostgreSQL Features Unsupported by GaussDB(DWS)

  • Table inheritance
  • Table creation features:
    • 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.
  • Define or change the security tag of an object.
  • 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 text search parsers.
  • Create, modify, and delete text search templates.
  • Create, modify, and delete collations.
  • Create and delete rules.
  • Register, modify, and delete languages.
  • Create, modify, and delete domains.
  • Define, modify, and delete the conversion of character set encoding.
  • Define and delete casts.
  • Define, modify, and delete user mapping.
  • Generate a notification.
  • Listen to a notification.
  • Stop listening to 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:
  • COPY FROM FILE and COPY TO FILE of COPY