-
Notifications
You must be signed in to change notification settings - Fork 106
Closed
Labels
enhancementNew feature or requestNew feature or requestsql2pgrollIssues relating to the sql2pgroll packageIssues relating to the sql2pgroll package
Description
At the moment it is not possible to add table constraints to tables during creation time.
We must extend create_table
to support creating table constraint.
- Add new
constraints
attribute tocreate_table
Addconstraints
option tocreate_table
andunique
constraint support #585 - Support
unique
constraints Addconstraints
option tocreate_table
andunique
constraint support #585 - Add support for
CHECK
constraints increate_table
operation #588 - Add support for primary key constraints in
create_table
operation #594 - Add support for foreign key constraints in
create_table
operation #597 - Add support for exclusion constraints in
create_table
operation #624 - Translate constraints in
CREATE TABLE
statements into pgroll operations - unify configuration options for all constraints in columns and tables
- foreign key: Expose foreign key constraint options in inline FK definition and in
create_constraint
#653 - primary key
- unique
- check: Add support for
no_inherit
on column level constraints and increate_constraint
operation #670 - deferrable column level constraints
- foreign key: Expose foreign key constraint options in inline FK definition and in
- Add exclusion constraints to
analyze
/read_schema
#658
andrew-farries, jokersoft and nanaimi
Metadata
Metadata
Assignees
Labels
enhancementNew feature or requestNew feature or requestsql2pgrollIssues relating to the sql2pgroll packageIssues relating to the sql2pgroll package