Deferrable constraints

General Questions/Discussions
1

Hi,

I’d like to specify in our DB schemas that some constraints (mainly foreign key contraints) are deferrable. I’ve not found how to do that in DB-VA 6.1. Is there a way to do that?

If not, can it be considered a feature request? We’d like to use it with PostgreSQL DDL code generation and for example to have a constraints being defined as:

ALTER TABLE "Customer_Contract" ADD CONSTRAINT "FKCustomer_Contract" FOREIGN KEY ("ContractId") REFERENCES "Contract" ("Id") ON UPDATE Cascade ON DELETE Cascade DEFERRABLE INITIALLY DEFERRED;

Thanks!

2

Hello Tonin,

Thank you for your email. I’ve forwarded the details for our engineers to follow up. We will keep you posted with any updates.

Best regards,
Rain Wong

3

Hey,

are there any updates on this problem. It would be great if you could post your solution here.

Thanks
fadh