graphql-engine
graphql-engine copied to clipboard
Add the ability to set Deferrable/Deferred from console.
The equivalent in pgAdmin is these two checks

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;
I think another good usecase for @defer could be when a model has a computed field that takes a while to formulate.
Thanks for consideration :)