When trying to restore a database, I am receiving the following error message
in the restore log:
gbak:activating and creating deferred index
FK_USER_DASHBOARD_ELEMENT_TO_US
gbak:cannot commit index FK_USER_DASHBOARD_ELEMENT_TO_US
gbak: ERROR:violation of FOREIGN KEY constraint
Robert martin wrote:
I have a field defined as UTF8. In my app I am trying to write and read
data from the field. I am succeeding on some levels but need to need to
confirm that the data being written and read from the field is correct.
I thought I might put some data in using a tool I
Sorry, but I still don't understand. I would like to refresh the attachment
records after a remote user has an unnatural disconnect. For example, Windows
freezes and the user must reboot. With my application, the connection count
must be accurate. So, if you would kindly give me an example of
Ok, so what you want is to get the real number of active connections
in your database, correct? So, it seems that I didnt understand you
question initially.
MON$ATTACHMENTS will return the number of active connections, that can
include the ones Firebird thinks are still active. This can include
You obtain the data from the MON$ATTACHMENTS table using a simple SELECT
query. Refreshing the query that reads the MON$ATTACHMENTS table is done by
comiting the transaction within which the query was issued and then
repeating the whole SELECT operation again.This will ensure you see the
latest
Hi,
I am using Firebird 2.5 on linux ( CentOS 6 )
I have set the firebird.conf temporary directories variable to point to our
large data storage folders.
However Firebird is determined not to use it and instead uses '/tmp'
So I have not been able to run any restore process as firebird runs out