Re: [Firebird-devel] FK Constraints and GTTs

2013-09-13 Thread unordained
-- Original Message --- From: "Vlad Khorsun" > 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 2.5.2 - OK f) restore

Re: [Firebird-devel] FK Constraints and GTTs

2013-09-12 Thread Vlad Khorsun
> -- Original Message --- > From: "Vlad Khorsun" >> 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 happen to

Re: [Firebird-devel] FK Constraints and GTTs

2013-09-12 Thread unordained
-- Original Message --- From: "Vlad Khorsun" > 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 happen to databases that

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 > 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 no link for free

Re: [Firebird-devel] FK Constraints and GTTs

2013-09-10 Thread Ann Harrison
On Tue, Sep 10, 2013 at 5:23 PM, Vlad Khorsun wrote: > > > > > First, thanks for the details (BTW, is there a link for the spec) > > AFAIR, SQL standard is not free, so there is no link for free download > (known > to me). I have draft versions of SQL 2003 and SQL 2008, but i don't > remember

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,

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

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 s

[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