MSC-PG0025

Sequence 'TEMPORARY | Temp' is not supported by Snowflake.

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

Severity

Low

Description

When creating a temporary sequence in PostgreSQL, it is only created for the active session and is automatically removed when exiting the session. However, this functionality is not available in Snowflake, so it is generated as a regular sequence. When executing, it is possible that a similar sequence name already exists, which will result in an error for an existing object.

Code Example

Input code:

PostgreSQL

CREATE TEMPORAL SEQUENCE sequence_name;

Output code:

Snowflake

CREATE
----** MSC-WARNING - MSC-PG0025 - TEMP OR TEMPORAL IS NOT SUPPORTED BY SNOWFLAKE. **
--       TEMPORARY
                 SEQUENCE sequence_name;

Recommendations

• If you have a creation problem, you can try renaming the sequence name to avoid collitions.

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