MSC-PG0008

Inheritance not supported

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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:

PostgreSQL

ALTER TABLE Table1
ADD CONSTRAINT const3 UNIQUE (zip);

Output Code:

Snowflake

--** MSC-WARNING - MSC-PG0008 - 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]