MSC-PG0008

Inheritance not supported

Severity

Low

Description

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

Code Example

Input Code:

ALTER TABLE Table1
ADD CONSTRAINT const3 UNIQUE (zip);

Output Code:

--** MSC-WARNING - MSC-PG0008 - TABLE INHERITANCE IS NOT SUPPORTED IN SNOWFLAKE. **
ALTER TABLE Table1
ADD CONSTRAINT const3 UNIQUE (zip);

Recommendations

Last updated