PRIMARY KEY ... DEFERRABLE INITIALLY....
733971Nov 27 2009 — edited Nov 27 2009Hi... I've some doubts about "DEFERRABLE INITIALLY IMMEDIATE" and "DEFERRABLE INITIALLY DEFERRED"
I think I ve understood the difference, but im not sure... So i write an example for having confirmation....
PRIMARY KEY (key) DEFERRABLE INITIALLY IMMEDIATE.. this is the default.... It means:
1. I insert a new row in the table;
2. It check if i can insert those row.
3. It does the COMMIT.
PRIMARY KEY (key) DEFERRABLE INITIALLY DEFERRED means:
1. I insert a ne row in the table;
2. I do the COMMIT;
3. It check if I can insert thos row.
That's correct?
thanks