SSC-EWI-PG0004
Exclude constraint not supported
Severity
Medium
Description
The exclude constraint used in PostgreSQL is not supported by Snowflake.
Code Example
Input Code:
CREATE TABLE Table1 (
id int,
EXCLUDE USING gist (id WITH &&)
);
Output Code:
CREATE TABLE Table1 (
id int,
!!!RESOLVE EWI!!! /*** SSC-EWI-PG0004 - EXCLUDE CONSTRAINT IS NOT SUPPORTED IN SNOWFLAKE. ***/!!!
EXCLUDE USING gist (id WITH &&)
)
COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": { "major": 0, "minor": 0, "patch": "0" }, "attributes": { "component": "postgresql", "convertedOn": "09/17/2024" }}';
Recommendations
If you need more support, you can email us at [email protected]
Last updated