I think this is a bug in FB 2.5, which causes a lot of headaches for me
too...Sometimes even restarting Firebird service doesn't help.
Does anyone know a solution for this? I'm using FB 2.5 64 bit Superserver on
Centos Linux
On Tuesday, November 26, 2013 11:16 AM, Kjell Rilbe
On Tue, Nov 26, 2013 at 8:03 AM, Kjell Rilbe kjell.ri...@datadia.se wrote:
Scenario, in a single connection I do this:
1. Start transaction.
2. Create table.
3. Commit.
4. Start transaction.
5. Insert rows.
6. Select using join with other tables.
7. Commit.
8. Start transaction.
9.
I have web clients, desktop clients and some service applications connected to
the database. And I'm not the only one writing applications on the database.
I have great difficulty when I need to change a stored procedure or table
structure. I receive object in use errors and can't do anything
arda wrote:
Maybe the database can store the versions of stored procedures transparently?
AFAICT, this already works that way, at least with Firebird Classic 2.1
on Linux which I mainly use in production.
Which version of Firebird are you using?
--
Milan Babuskov
Jesus A. García Zarco
AFAICT, this already works that way, at least with Firebird Classic 2.1
on Linux which I mainly use in production
I think classic and superclassic do not support meta data change while in use,
only superserver support it.
[Non-text portions of this message have
-- Original Message ---
From: arda atuncce...@duzen.com.tr
I have great difficulty when I need to change a stored procedure or
table structure. I receive object in use errors and can't do
anything at day time. I need to wait till about midnight and
disconnect all clients.