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 :

• https://github.com/ariga/atlas/blob/856a70c3c532b3c2111b803bc2be6594bed74228/sql/postgres/diff.go#L232
• https://github.com/ariga/atlas/blob/856a70c3c532b3c2111b803bc2be6594bed74228/sql/schema/schema.go#L328
• https://github.com/ariga/atlas/blob/856a70c3c532b3c2111b803bc2be6594bed74228/sql/internal/sqlx/diff.go#L502

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.