Hi,
i followed the guideline here
http://www.firebirdsql.org/manual/nullguide-alter-pop-tables.html
to change an already populated column to nullable (constraint has no name).
The guideline involves updating a system table in such a case and in 3.0 they
are read-only now. What would be the way t
29.04.2016 18:19, Ralf Jansen ralf.jan...@mailstore.com [firebird-support]
wrote:
> What would be the way to do it now?
Read Release Notes about changes in DDL.
--
WBR,
Hi,
I wanted to experiment with the dbcrypt sample deployed with FB 3.0. But all I
found was the source code file in the examples folder.
Is there any documentation on what is needed to get a compiling project? And
some documentation about the used/needed interfaces in that example and how
they
Hi,
unfortunately, my question didn't get anything as response so I assume that
there isn't a documentation dedicated to writing plugins.
Let me try a more concrete question on the subject.
I was reading the Release Notes here
http://www.firebirdsql.org/file/documentation/release_notes/html/en/3
What Exception?
Sql92 seems to not state anything in that regard. So this belongs presumably
into the implementation specific area.
I’m sure if it had been defined there it would not be a clear yes/no thing.
For example, Firebird allows this even when the select clause contains DISTINCT
so that
Hi,
really? The groups disclaimer states „DO NOT USE THIS LIST FOR SUPPORT
QUESTIONS REGARDING RELEASED VERSIONS.”
Ralf
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Montag, 9. Mai 2016 13:21
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-
Hi,
is there an easy/official way to check the ODS versions?
I was going the gstat route but the 2.5 gstat doesn't know anything about ODS
12 and up and the 3.0 gstat only knows about ODS 12 and up.
Both gstats throw errors in case of an unknown ODS Version but it feels wrong
relying on that erro
I missed to say that it’s all about embedded usage. So before executing any
statement I would need to know what firebird library to use for connecting.
My use case is actually detecting pre ODS 12 databases and doing a
backup/restore to get them into the current format.
From: firebird-support@
No Server involved. I am directly using the fbembed/fbclient.dll for for
connecting to an fdb file.
I'm a Firebird embedded user.
From: firebird-support@yahoogroups.com [firebird-support@yahoogroups.com]
Sent: Thursday, May 12, 2016 20:18
To: firebird-support@yah
Hi,
i have a .Net application that is using firebird embedded 2.5 and 3.0
concurrently. That is needed for a smooth, almost uninterrupted, transition
from 2.5 to 3.0 databases for that application.
Starting the application and using 2.5 and 3.0 databases in parallel simply
works. But after doin
I just learned that enabling encryption via "ALTER DATABASE ENCRYPT etc."
starts encryption of the database asynchronously in the background.
Are there any settings or something to change/manage the behavior or monitor
the progress?
For example, I would need to be able to start stop that backgro
Yes, monitoring seems to be possible. Automating gstat isn't really nice but
looking at the system tables should be ok.
But what about stopping/resuming the progress?
-Ursprüngliche Nachricht-
Von: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Gesendet: Diens
Hi,
Ø how often do you encrypt database? i suppose that only once.
Sure every database only once. In this case a high 6-digit count of databases
around the world that should be upgraded/encrypted only once automatically and
should not interfere with the backup strategy of the
responsible admi
-support] Firebird 3 encryption in the background
02.08.2016 15:39, Ralf Jansen ralf.jan...@mailstore.com [firebird-support]
wrote:
> But what about stopping/resuming the progress?
Encryption is stopped when database unloaded for superserver or at
disconnect for classic. Encryption is resu
Need to come back to this. I can reproduce the behavior with flamerobin as
client.
Connect via the embedded client to a database start encryption, disconnect. I
can see that a handle to the database is still opened by flamerobin even if
disconnected and I can monitor the encryption progress via
Need to come back to this. I can reproduce the behavior with flamerobin as
client.
Connect via the embedded client to a database start encryption, disconnect. I
can see that a handle to the database is still opened by flamerobin even if
disconnected and I can monitor the encryption progress via
Thanks Vlad,
i wasn’t aware of the „linger“-feature. Shouldn’t be a factor here. I did not
enabled that feature and I’m under the impression that Embedded != Superserver.
I have a multitude of problems with the encryption in embedded fb. This is just
one of it. When I have enough understanding a
I'm trying to monitor encryption and look at Mon$Database for it.
Documentation has this example "select MON$CRYPT_PAGE * 100 / MON$PAGES from
MON$DATABASE"
As indicator that encryption it done I thought that the value of CRYPT_PAGE
should be equal to PAGES (PAGES - CRYPT_PAGE == 0).
But it seem
Hi,
CORE-5154 is marked as fixed with the 3.0.1 release but I still have that
problem with a current nightly build (3.0.2.32615) and stumble into this when
having german umlauts (from Codepage 1252) in the path to the database.
As I'm using Firebird via the.Net Provider I'm struggling if it's st
Hi,
I'm using firebird embedded (2.5 and 3) in an on-premise solution. I get
sometimes reports of slow behaviour and when checking those databases I can see
that some or all indexes are disabled.
I can than simply enable those indexes and all seems well afterwards. Gfix does
not find any proble
Hi Neil,
I also have that experience when restoring. But as you said only when there are
problems in the underlying table. Like duplicate values in a column that has a
unique index.
In that case i can only reenable the index when fixing the table. In the cases
I'm talking about there are no obv
Hi,
I have just read the general notes for FB 3.0.3 especially the alert for users
of encryption via a plugin.
That alert seems to refer to CORE-5735. But that issue does not seem to be
readable without special permissions. At least I'm not allowed to read that one
when signed in to the tracker.
I’m using multiple firebird embedded versions from within the same process
without fiddling around in environment variables like FIREBIRD_LOCK or conf
files of the different firebird versions.
There should be no need in doing anything special. Just use the version(s) you
like.
Ralf
Von: fire
23 matches
Mail list logo