hasura / hasura/graphql-engine

Add the ability to set Deferrable/Deferred from console.

Open
#7,440 1 comment 2 reactions 0 assignees View on GitHub
c/console estimate/M k/enhancement p/longterm
Dominant language
TypeScript
Stars
32.1k
Forks
3k
PR merge metrics
PR metrics pending

Description

The equivalent in `pgAdmin` is these two checks

![image](https://user-images.githubusercontent.com/5978905/130479574-0de3c36c-71ce-48a0-859a-e20947e91289.png)

right now we have to go and manually edit the generated migration to add `DEFERRABLE INITIALLY DEFERRED`.

Example Migration:

```
ALTER TABLE public.xxx
ADD CONSTRAINT xxx_id_fkey FOREIGN KEY (y_id)
REFERENCES public.yyy (id) MATCH SIMPLE
ON UPDATE NO ACTION
ON DELETE NO ACTION
DEFERRABLE INITIALLY DEFERRED;
```

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.