InsertInsightsDatabaseEntityTypesMigration

Database	Schema	Description
Insights	system	Insert the missing entity type values for the release.

SQL Statements

CREATE TEMPORARY TABLE code_entity_types (value text);



WITH existing_members AS
(
    SELECT unnest(enum_range(NULL::system.entity_type)) AS member
)
SELECT
    cet.value AS missing_entity_type
FROM
    code_entity_types cet
    LEFT JOIN existing_members em ON cet.value = em.member::text
WHERE
    em.member IS NULL