|
| commit statement not work |
 |
Wed, 16 May 2007 11:01:35 +020 |
Hi Gelein.
I test script with "commit" statement.
Create table X1 ...
commit;
create second table X2
add foreign key from table X2 to X1
run script
it not work becaouse commit realy not commit transaction
and i get table X1 is in use error.
When i do the same in IBConsole 7.5.0.1 it work ok.
Karol Bieniaszewski
|
| Post Reply
|
| Re: commit statement not work |
 |
16 May 2007 13:29:33 -0700 |
Karol Bieniaszewski wrote:
> Hi Gelein.
>
> I test script with "commit" statement.
>
> Create table X1 ...
> commit;
> create second table X2
> add foreign key from table X2 to X1
>
> run script
>
> it not work becaouse commit realy not commit transaction
> and i get table X1 is in use error.
>
> When i do the same in IBConsole 7.5.0.1 it work ok.
> Karol Bieniaszewski
Karol,
If you are using 8.0.0.50 please check the transaction options if the
Access mode is "Write".
--
|
| Post Reply
|
| Re: commit statement not work |
 |
Thu, 17 May 2007 09:06:21 +020 |
Użytkownik "Gelein van de Voorde" <gelein@gvsnet.nl> napisał w
wiadomości
news:464b69ad$1@newsgroups.borland.com...
> Karol Bieniaszewski wrote:
>
>> Hi Gelein.
>>
>> I test script with "commit" statement.
>>
>> Create table X1 ...
>> commit;
>> create second table X2
>> add foreign key from table X2 to X1
>>
>> run script
>>
>> it not work becaouse commit realy not commit transaction
>> and i get table X1 is in use error.
>>
>> When i do the same in IBConsole 7.5.0.1 it work ok.
>> Karol Bieniaszewski
>
> Karol,
> If you are using 8.0.0.50 please check the transaction options if the
> Access mode is "Write".
>
yes i have write + read commited + recver
Karol Bieniaszewski
|
| Post Reply
|
| Re: commit statement not work |
 |
Thu, 17 May 2007 09:22:36 +020 |
Użytkownik "Gelein van de Voorde" <gelein@gvsnet.nl> napisał w
wiadomości
news:464b69ad$1@newsgroups.borland.com...
> Karol Bieniaszewski wrote:
>
>> Hi Gelein.
>>
>> I test script with "commit" statement.
>>
>> Create table X1 ...
>> commit;
>> create second table X2
>> add foreign key from table X2 to X1
>>
>> run script
>>
>> it not work becaouse commit realy not commit transaction
>> and i get table X1 is in use error.
>>
>> When i do the same in IBConsole 7.5.0.1 it work ok.
>> Karol Bieniaszewski
>
> Karol,
> If you are using 8.0.0.50 please check the transaction options if the
> Access mode is "Write".
>
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
|
| Post Reply
|
| Re: commit statement not work |
 |
18 May 2007 12:26:14 -0700 |
> 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?
|
| Post Reply
|
|
|
|
|
|
|
|
|
|