Skip to content

[Bug] Constraint trigger incorrectly reported as non-deferrable/deferred #899

@ethanresnick

Description

@ethanresnick

To reproduce:

  1. Create a table and give it a DEFERRABLE INITIALLY DEFERRED constraint trigger.
  2. Verify that the trigger is created successfully, with tgdeferrable and tginitdeferred both set to true in pg_catalog.pg_trigger.
  3. View the table's definition in Postico's DDL view; observe that the DDL for the trigger trigger shows as NOT DEFERRABLE.

Postico Version 2.1.2 (9702)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions