[Firebird-devel] Fwd: SF.net SVN: firebird:[61378] firebird/trunk/src/jrd/scl.epp

[Adriano dos Santos Fernandes]

-------- Forwarded Message --------
Subject:        [Firebird-checkins] SF.net SVN: firebird:[61378]
firebird/trunk/src/jrd/scl.epp
Date:   Mon, 20 Apr 2015 17:04:42 +0000
From:   alexpeshk...@users.sourceforge.net
To:     firebird-check...@lists.sourceforge.net



Revision: 61378
          http://sourceforge.net/p/firebird/code/61378
Author:   alexpeshkoff
Date:     2015-04-20 17:04:42 +0000 (Mon, 20 Apr 2015)
Log Message:
-----------
Disabled use of system tables in foreign key constraints

...

+       if (systemFlag == 1 && !attachment->isRWGbak())
+       {
+               // Someone is going to reference system table in FK
+               // Usually it's not good idea
+               raiseError(mask, SCL_object_table, reln_name, "");
+       }
+


I understand that is a very good idea for one to associate their
"metadata" with real objects with a foreign key to a system table,
specially if this foreign key has update/delete cascade, hence not
interrupting the engine from doing anything.

Why not?


Adriano


------------------------------------------------------------------------------
BPM Camp - Free Virtual Workshop May 6th at 10am PDT/1PM EDT
Develop your own process in accordance with the BPMN 2 standard
Learn Process modeling best practices with Bonita BPM through live exercises
http://www.bonitasoft.com/be-part-of-it/events/bpm-camp-virtual- event?utm_
source=Sourceforge_BPM_Camp_5_6_15&utm_medium=email&utm_campaign=VA_SF
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel