Ühel kenal päeval, E, 2007-03-26 kell 16:05, kirjutas Joris Dobbelsteen: > Oracle has choosen to allow constraint enforcement by locking on the > parent tuple. In contrast postgres has chosen (historically, see RI > triggers) to fail on detecting conflicting newly inserted rows (the > cross-check).
Could you give an example, where postgresql fails to detect conflicting newly inserted rows ? -- ---------------- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend