SSC-EWI-PG0003

Inheritance not supported

Severity

Low

Description

Inheritance between tables is allowed in PostgreSQL, but Snowflake does not support it. For more information about inheritance in PostgreSQL click here.

Code Example

Input Code:

PostgreSQL

IN -> PostgreSQL_01.sql

ALTER TABLE Table1
ADD CONSTRAINT const3 UNIQUE (zip);

Output Code:

Snowflake

OUT -> PostgreSQL_01.sql

!!!RESOLVE EWI!!! /*** SSC-EWI-PG0003 - TABLE INHERITANCE IS NOT SUPPORTED IN SNOWFLAKE. ***/!!!
ALTER TABLE Table1
ADD CONSTRAINT const3 UNIQUE (zip);

Recommendations

• If you need more support, you can email us at [email protected]