[firebird-support] Create database

2013-08-13 Thread Marco Sucuzhañay
Dear, I can generate a script as a multi file database to create it with the same structure in another server, thanks [Non-text portions of this message have been removed]

[firebird-support] Running gbak 2.5 on RH9

2013-08-13 Thread James Calfee
We stuck using gbak 1.5 to perform backup and restores on remote FB 2.5 databases. Obviously we would like to upgrade the gbak program to version 2.5 and avoid this hack. Gbak depends on libstdc++.so.6. The repository on this old box only provides libstdc++.so.5. Is it possible to include the l

RE: [firebird-support] Transaction waits

2013-08-13 Thread Svein Erling Tysvær
>> "insert into TABLE_B (ID, TABLE_A_ID) values (1, 5);" >> Why does the second transaction wait? > >I might be thinking too simple, but for me this looks obvious. > >If the first transaction translates to "Update Table_A set ID = 5 where >ID = 5", >it does not make too much sense, but shou

Re: [firebird-support] Transaction waits

2013-08-13 Thread André Knappstein
> "insert into TABLE_B (ID, TABLE_A_ID) values (1, 5);" > Why does the second transaction wait? I might be thinking too simple, but for me this looks obvious. If the first transaction translates to "Update Table_A set ID = 5 where ID = 5", it does not make too much sense, but should not aff

[firebird-support] Transaction waits

2013-08-13 Thread Roland Turcan
Hello firebird-support@yahoogroups.com! I have two tables: TABLE_A (ID integer) TABLE_B (ID integer, TABLE_A_ID integer) TABLE_B.TABLE_A_ID has foreign key to TABLE_A.ID TABLE_A contains a row e.g. with ID=5 one transaction updates the row with "update TABLE_A set id=id where id=5", but do

Re: [firebird-support] Performance with heavily updated table

2013-08-13 Thread Tim Ward
We are using 2.1.5 for production. I just used 2.5 for an experiment. On 12/08/2013 19:15, liviusliv...@poczta.onet.pl wrote: > > Hi, > > you write that you have FB2.5 – why you have ODS version 11.1 not 11.2? > I have 2.5.3 and all DB have ODS11.2 > > regards, > Karol Bieniaszewski > > From: Tim

Re[2]: [firebird-support] I can move Firebird database

2013-08-13 Thread Dmitry Kuzmenko
Hello, Jorge! Monday, August 12, 2013, 8:54:17 PM, you wrote: JAB> http://tkb.amano.com/phpkb/article.php?id=181 could help. really? This piece of auto-generated crap can help? You read the description of that "solution"? :-) In the case of moving db+secondary files the only HEX editor, or old

Re: Odp: [firebird-support] Performance with heavily updated table

2013-08-13 Thread Thomas Steinmaurer
Tim, > I believe the relevant part of the gstat output for the table in > question to be as below, please let me know if I've got that wrong. > (Names changed but otherwise unaltered.) My interpretation, which may be > faulty, of > > Average version length: 0.00, total versions: 0, max versions: 0