Ühel kenal päeval, N, 2006-06-08 kell 08:38, kirjutas Albert Cervera Areny: > Hi, > after starting this thread > http://archives.postgresql.org/pgsql-hackers/2006-05/msg00222.php, I thought > I'd finally go for making foreign keys my own way instead of trying to patch > PostgreSQL. However, I've realized that managing foreign keys with my own > PL/SQL or C function isn't possible as I need DEFERRED checks which are > currently only available for foreign keys.
remember that you must manage both ends of foreign key. and you have to lock the other table while changing values at either end. -- ---------------- 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 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
