Norbert Saint Georges n...@tetrasys.eu [firebird-support] a écrit :
> where can I find them?
ok in ../../yvalve/perf.cpp
#define TOTAL_COUNTERS 11
// we use case-insensitive names, here they are written with capital
letters for human readability
KnownCounters knownCounters[TOTAL_COUNTERS] = {
> Also, apparently, this is not a blanket restriction, since I can
> successfully run the UPDATE RDB$PROCEDURES on at least 1 other
> converted DB (that is essentially the same as the DB I cannot runthis
> UPDATE on).
Smells like a privileges problem. The updater has to be SYSDBA,
Thanks for the heads up, Mark...
However, Carlos' explanation when I read through it again, does appear to be a
little confusing at the least.
Why not simply disallow it altogether and be consistent?
As I just mentioned in another reply to you, no one breaks into databases to
steal
My thoughts exactly...
Even with scripting out all the database objects before the sources are
deleted, sorting through them on large database can become a timely effort if
you need to recompile only a few.
Besides, who breaks into a database to steal stored procedure code??? And if
On 2018-05-31 17:51, Chuck Belanger phytot...@lanset.com
[firebird-support] wrote:
> Hello:
>
> Per googling and Carlos Cantu's FB3 Migration Guide (page: 110), we are
> still allowed to set RDB$PROCEDURE_SOURCE = null, and yet when trying
> to
> do just that on my app's converted FB2.5 to FB3
On 2018-05-31 18:14, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
> I just finished a complete review of Carlos' migration guide. I read
> it quite carefully but completely missed what appears to be a
> contradiction in his explanations for the updating of the source-code
> fields
Hi All,
I found some "firebird terminated abnormally (-1)" errors in
firebird.log on my development machine. How can I detect it's source?
My tip is a self made UDF (no input parameter, one TIMESTAMP output and
written with Free Pascal). Can I stress test the UDF/problem somehow? (I
know the
31.05.2018 18:14, blackfalconsoftw...@outlook.com [firebird-support] wrote:
> However, maybe Firebird 3.x.x does NOT allow this as Carlos' manual
> suggests...
I've just trued:
SQL> show version;
Server version:
Firebird/Windows/Intel/i386 (access method), version "WI-V3.0.2.32703 Firebird
Thank you. However, I am not clear at all about how to do this with SQL DDL.
Also, apparently, this is not a blanket restriction, since I can
successfully run the UPDATE RDB$PROCEDURES on at least 1 other converted
DB (that is essentially the same as the DB I cannot run this UPDATE on).
Hello:
Per googling and Carlos Cantu's FB3 Migration Guide (page: 110), we are
still allowed to set RDB$PROCEDURE_SOURCE = null, and yet when trying to
do just that on my app's converted FB2.5 to FB3 database, I am getting
"update not allowed on Systems tables." ISC ERROR CODE 335545030
I
Hello,
I only found that in isql.epp
const char* ISQL_COUNTERS_SET = "CurrentMemory, MaxMemory, RealTime,
UserTime, Buffers, Reads, Writes, Fetches";
what are the other possibilities or where can I find them?
--
Norbert Saint Georges
http://tetrasys.fi
Hello,
Thanks for your reply.
1. Why do you remove all FK?
--> Data update covers all data's tables. I must remove all FK to be able
to insert, delete records.
2. Why do you still use such old Firebird version?
--> You are wright. It's a big client database and I mist have it's
agreement to
Hi,
Two questions 1. Why do you remove all FK?2. Why do you still use such old
Firebird version?
Many things was fixed since FB1.5 and i suppose that only real fix to your
problem is using recent FB.
You can try disconnect after every FK.You can also try do select count(*) from
updated tables
Hello everybody,
I've an application witch update a database data.
The process to update data is :
1. Delete all foreign keys
2. Execute all update commands (insert, update, delete)
3. Create foreign keys
The problem is that foreign key creation return an error for some FK (50
from
14 matches
Mail list logo