Wednesday, August 8, 2012

Re: about deferrable constraint in Google cloud SQL

I'm not familiar with DB2. In MySQL you can disable the foreign key constraints [1] but you cannot bypass the normal constraints.

[1] http://dev.mysql.com/doc/refman/5.5/en/server-system-variables.html#sysvar_foreign_key_checks

-- Razvan ME


On Wed, Aug 8, 2012 at 6:44 PM, Rast Rastapana <tung_suplex@hotmail.com> wrote:
Due to some task needed to bypass some value in the beginning (NULL value can't insert into DB because of the integrity constraint) ,
Can i defer integrity constrain on my work like DB2 in each transaction or have another way to defer validation /checking at first but it works  ?
(Like "DEFERRABLE"  declaration on Google Cloud SQL )

Best regards.




No comments:

Post a Comment