Postgres: inspect: for foreign key deferrable initially deferred

[alexisvisco]

Hello, seeing that a diff is generating this (using postgres)

ALTER TABLE "public"."order_items" ADD
 CONSTRAINT "fk_order_items_order_id" FOREIGN KEY ("order_id") REFERENCES "public"."orders" ("id") ON UPDATE NO ACTION ON DELETE NO ACTION;

While I have set this in the schema .sql :

constraint fk_order_items_order_id foreign key (order_id) references orders (id) deferrable initially deferred

I would like to contribute opening a PR :

Seems like this codes need to be impacted :

• atlas/sql/postgres/diff.go

  Line 232 in 856a70c

  func (*diff) ReferenceChanged(from, to schema.ReferenceOption) bool {

• atlas/sql/schema/schema.go

  Line 328 in 856a70c

  const (

• atlas/sql/internal/sqlx/diff.go

  Line 502 in 856a70c

  func (d *Diff) fkChange(from, to *schema.ForeignKey) schema.ChangeKind {

Could you give me some hint so that I can open a pull request ?

Thanks you :)

[C-Deck]

This commit adds the inspect/diff pieces you may need. I'm not familiar with the tooling functionality that atlas does since I use this package like Ent does. If support in the tooling is needed to merge this, someone else will have to take over.

[a8m]

The issue was resolved with latest Atlas build, and it will be officially released in next version. You can define the deferrable attribute on the following blocks: foreign_key, primary_key, unique, and exclude. For example:

table "users" {
  // ...
  foreign_key "constraint_name" {
    columns     = [...]
    ref_columns = [...]
    deferrable  = INITIALLY_IMMEDIATE // Or: INITIALLY_DEFERRED
  }
}

See the HCL docs for more info: https://atlasgo.io/hcl/postgres#table.foreign_key-attributes