0
Under review

[Postgres] Constraint added automatically NOT DEFERRABLE INITIALLY IMMEDIATE

yun lee 10 months ago • updated by Mariusz Zakrzewski 10 months ago 1

By default is NOT DEFERRABLE and if it is NOT DEFERRABLE it is also IMMEDIATE, right?


Should I use those even it is set by default? Or it does imply something other?


Because the SQL generates with this Keyword in anyplace. and I'm not sure about the implications of all.


Under review

You are right - NOT DEFERRABLE is the same as NOT DEFERRABLE  INITIALLY IMMEDIATE.


There is no difference between those two. Scripts generated by our platform is just a bit verbose.