doc-exports/docs/dws/dev/dws_06_0006.html
Lu, Huayi a24ca60074 DWS DEVELOPER 811 version
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-01-19 13:37:49 +00:00

4.7 KiB

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:
  • TO PUBLIC of GRANT
  • COPY FROM FILE and COPY TO FILE of COPY