Skip to content

View update error causes fixtures to stop #43

@davenquinn

Description

@davenquinn

This error should be handled by the run_sql function, allowing the statement to be skipped when running fixtures.

NotSupportedError: (psycopg2.errors.FeatureNotSupported) cannot alter type of a column used by
a view or rule
DETAIL:  rule _RETURN on view macrostrat_api.col_group_with_cols depends on column "project"

[SQL: ALTER TABLE "macrostrat"."projects" ALTER COLUMN "project"
   SET DATA TYPE text USING "project"::text;]
(Background on this error at: https://sqlalche.me/e/20/tw8g)

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions