Re: commit statement not work

Article View: borland.public.interbase.ibconsole

Article #142

Back to borland.public.interbase.ibconsole Previous Next

#142

From: Karol Bieniaszewski
Date: Mon, 21 May 2007 06:25

33 lines
1897 bytes

U�ytkownik "Gelein van de Voorde" <gelein@gvsnet.nl> napisa� w wiadomo�ci 
news:464dfdd6@newsgroups.borland.com...
>> try this - copy all to SQL window:
>>
>> CREATE TABLE XXX
>> (
>> ID INTEGER NOT NULL PRIMARY KEY
>> );
>>
>> commit;
>> CREATE TABLE YYY
>> (
>> ID Integer NOT NULL primary key,
>> ID_XXX INTEGER
>> );
>>
>> ALTER TABLE YYY ADD FOREIGN KEY (ID_XXX) REFERENCES XXX(ID) ON DELETE
>> NO ACTION ON UPDATE CASCADE;
>>
>> and run whole script
>> you get object XXX is in use
>> try the same in IBConsole 7.5.0.1
>>
>> Karol Bieniaszewski
> Karol,
> I can not reproduce this. Do you have nowait enabled?
> If so, do you have journaling enabled?
> Are you testing against a local or remote database?

Access mode: write
Isolation Level: read commited + rec version
Lock resolution: no wait

Technical Details

Message-ID: <46513a53$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References:

<464ac764@newsgroups.borland.com> <464b69ad$1@newsgroups.borland.com> <464c01ae$1@newsgroups.borland.com> <464dfdd6@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: f4565,48b8665fdcbfdfee
X-Google-Attributes: gidf4565,public
X-Google-Language: ENGLISH,ASCII
From: "Karol Bieniaszewski" <liviuslivius@poczta.onet.pl>
Newsgroups: borland.public.interbase.ibconsole
References: <464ac764@newsgroups.borland.com> <464b69ad$1@newsgroups.borland.com> <464c01ae$1@newsgroups.borland.com> <464dfdd6@newsgroups.borland.com>
Subject: Re: commit statement not work
Date: Mon, 21 May 2007 08:25:38 +0200
Lines: 35
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 195.205.151.58
Message-ID: <46513a53$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1179728467 195.205.151.58 (20 May 2007 23:21:07 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx02.iad01.newshosting.com!newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message