Skip to content

sql: DROP SEQUENCE CASCADE, DROP TABLE => sequence #20965

@vilterp

Description

@vilterp

Expected (PG behavior):

  • DROP SEQUENCE seq CASCADE removes sequence-using DEFAULT expressions from tables using it
  • DROP TABLE a drops sequences table a is using, if no other tables are using them

Current state:

  • DROP SEQUENCE CASCADE doesn't parse
  • DROP TABLE doesn't affect sequences

Metadata

Metadata

Assignees

No one assigned

    Labels

    A-schema-changesA-sql-pgcompatSemantic compatibility with PostgreSQLA-sql-sequencesSequence handling in SQLC-enhancementSolution expected to add code/behavior + preserve backward-compat (pg compat issues are exception)

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions