Re: [Firebird-devel] FK Constraints and GTTs

2013-09-13 Thread unordained
-- Original Message --- From: Vlad Khorsun hv...@users.sourceforge.net a) using script from CORE-4212 and FB 2.1.2, created database with wrong FK. b) add some data into permanent table at_namespace c) backup this database d) restore using FB 2.1.2 - OK e) restore using FB

Re: [Firebird-devel] FK Constraints and GTTs

2013-09-12 Thread unordained
-- Original Message --- From: Vlad Khorsun hv...@users.sourceforge.net It is physically impossible to check detail data in all instances of detail GTT when master record is changed. Regards, Vlad --- End of Original Message --- At time of upgrade, what will

Re: [Firebird-devel] FK Constraints and GTTs

2013-09-12 Thread Vlad Khorsun
-- Original Message --- From: Vlad Khorsun hv...@users.sourceforge.net It is physically impossible to check detail data in all instances of detail GTT when master record is changed. Regards, Vlad --- End of Original Message --- At time of upgrade, what will

Re: [Firebird-devel] FK Constraints and GTTs

2013-09-11 Thread Frank Schlottmann-Gödde
Am 10.09.2013 23:34, schrieb Ann Harrison: On Tue, Sep 10, 2013 at 5:23 PM, Vlad Khorsun hv...@users.sourceforge.net mailto:hv...@users.sourceforge.net wrote: First, thanks for the details (BTW, is there a link for the spec) AFAIR, SQL standard is not free, so there is

[Firebird-devel] FK Constraints and GTTs

2013-09-10 Thread Leyne, Sean
In tracker case 4212, Vlad Khorsun wrote: It is documented since introducing GTT in v2.1 that constraints between temporary and permanent tables is forbidden. This requirement is per SQL standard. I want to be sure that this is correct (sorry Vlad), cus it seems wrong. I can see that

Re: [Firebird-devel] FK Constraints and GTTs

2013-09-10 Thread Vlad Khorsun
In tracker case 4212, Vlad Khorsun wrote: It is documented since introducing GTT in v2.1 that constraints between temporary and permanent tables is forbidden. This requirement is per SQL standard. I want to be sure that this is correct (sorry Vlad), cus it seems wrong. 11.8

Re: [Firebird-devel] FK Constraints and GTTs

2013-09-10 Thread Leyne, Sean
In tracker case 4212, Vlad Khorsun wrote: It is documented since introducing GTT in v2.1 that constraints between temporary and permanent tables is forbidden. This requirement is per SQL standard. I want to be sure that this is correct (sorry Vlad), cus it seems wrong.

Re: [Firebird-devel] FK Constraints and GTTs

2013-09-10 Thread Vlad Khorsun
In tracker case 4212, Vlad Khorsun wrote: It is documented since introducing GTT in v2.1 that constraints between temporary and permanent tables is forbidden. This requirement is per SQL standard. I want to be sure that this is correct (sorry Vlad), cus it seems wrong. 11.8

Re: [Firebird-devel] FK Constraints and GTTs

2013-09-10 Thread Leyne, Sean
I will point out that, the specs does allow for GTT to reference GTT, which is not what your original comment stated (that a GTT could not have any dependencies/references). I meant exactly this, sorry if it was not clear. I have added comments to the 2 related tracker cases,