[firebird-support] object is in use

2013-07-10 Thread tomkrej
Hi, sometimes when I need to change the database object - view/procedure - this error is raised. Can I detect which user/transaction causing this problem? What can I do to not have this error? Thank you in advance. Tom

[firebird-support] RDB$PAGES

2013-05-23 Thread tomkrej
Hi, I'd like to get the count of all types of db pages. If I run the query select count(*), rdb$page_type from rdb$pages group by rdb$page_type I got only about 2200 pages, but there are about 320 000 pages in DB. And the result of query contains only - 3, 4, 6 and 9 type of page. How can I

[firebird-support] Problems with full ICU on 64bit firebird

2011-12-14 Thread tomkrej
Hello, we have a database with UTF8 fields, but we need czech ordering. We started with 32bit FB2.1, we used full ICU 3.0 for win32 (msvcr7.1) and define our collations according to full ICU capabilities - no problem. Then we upgrade to FB2.5 win32 - use the same ICU - no problem. But when we

[firebird-support] Problem with compound index

2011-09-07 Thread tomkrej
Hi all, I have interesting problem with compound index. I have records in one table divided in a groups by field TYP and each record has its name field TRIDNAZ TRIDNAZ is varchar(40) character set WIN1250 collation PXW_CSY TYP is smallint I had 2 indexes - on TRIDNAZ only, and on TYP, TRIDNAZ

[firebird-support] Re: Database Trigger - Is is possible to preventing disable db trigger from ISQL?

2011-08-09 Thread tomkrej
Try to create role SYSDBA in your database, then You prevent SYSDBA to connect to database. Tom --- In firebird-support@yahoogroups.com, trskopo trskopo@... wrote: Dear Thomas Steinmaurer, Thanks for your reply. I don't give SysDba password to users, but since Firebird is freely