Instead of implementing a pool of connections that the system implicitly
manages, it might be better to implement named connections as it is done
in Postgres
(https://www.postgresql.org/docs/current/static/contrib-dblink-function.html)?
Which the user manages and re-uses as he needs - he knows
21.05.2018 14:42, Vlad Khorsun via Firebird-devel пишет:
I don't see how persistent connections in Postgres could be reused by
different user sessions.
No, in Postgres you can reuse only your own connections.
Nevertheless, it seems to me that this approach also solves the original
task
Hello.
The background of this task in CORE-5612, it contains research details
and conclusions.
How much I understood, there is no way to specify what index should be
used at system inquiries from *.epp files?
If not, is it possible to enable the create/delete, enable/disable
indexes on
sertString(isc_dpb_gbak_attach, FB_VERSION, fb_strlen(FB_VERSION))),
but then you need to remove the check for the creator of database
(attachment->att_flags & ATT_creator).
2018-02-19 16:38 GMT+03:00 Rashid Abzalov (JIRA) <trac...@firebirdsql.org>:
>
> [ http://tracker.firebirdsql.
I was not entirely right.
The above tests were carried out on version 2.5.5, where the result was
obtained in 30 minutes.
After upgrading to version 2.5.8, the test shows the same results
regardless of the processor ~ 1 min.
Also checked for version 3.0, with additional indexes created in
The implemented feature allows changing user indexes to any users.
Perhaps it makes sense to allow this only for users who are members of
the RDB$ADMIN role?
Or is it better to check by analogy with database triggers -
SCL_check_database(tdbb, SCL_alter)?
How much I understood, there is no way to specify what index should be
used at system inquiries from *.epp files?
I have the same understanding
It seems to me that the solution of this problem would be of much more
use. Then you could just create additional system indexes and use those
13.03.2019 18:07, Alex Peshkoff via Firebird-devel пишет:
Pre-FB3 versions made it possible to modify system tables directly
including creation of new triggers on them. Currently such triggers are
restored from 2.5 backup and can't be removed afterwards. I suggest to
skip such triggers during
Behavior of Oracle 11 + Postgres 9.6.
*Common DDL*:
create table master (id number primary key);
create table detail (id number primary key, master number);
alter table detail add foreign key (master) references master(id) on delete
cascade;
*Oracle (2 sqlplus windows)*:
tx1:
set transaction
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0 RC 1
Environment: 3.0.0.32136_0_x64_RC1
Reporter: Rashid Abzalov
create database 'c:\test.fdb' page_size 16384 user 'SYSDBA' password
'masterkey' default character set UTF8
only
Reporter: Rashid Abzalov
Attachments: MultiThreaded.zip
This example works fine in Embedded v2.5 but fails in Embedded v3.0.
Test query: select * from RDB$COLLATIONS (you can use any other)
Sources of client application is attached. Compiled binaries are attached too
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.1
Reporter: Rashid Abzalov
This example works in v2.5 but fails in v3.0.
create database 'localhost:c:\test.fdb' page_size 16384 user 'SYSDBA' password
'masterkey' default character set UTF8 collation
Type: Bug
Components: Engine
Affects Versions: 3.0.1
Environment: Windows, Firebird-3.0.1.32609_0_x64
Reporter: Rashid Abzalov
This example works in v2.5 but fails in v3.0.
Query:
select A.ID
from test_view A
inner join RDB$TYPES D1 on D1.rdb$type = A.ID
Components: Engine
Affects Versions: 3.0.2, 2.5.7
Reporter: Rashid Abzalov
Attachments: BUILD.sql
With a large number of existing views, the compilation of new views (or drop
existing) is very slow and the time increases as the number of views increases.
Time
Project: Firebird Core
Issue Type: Sub-task
Components: Engine
Affects Versions: 3.0.3, 3.0.2, 3.0.1, 3.0.0
Reporter: Rashid Abzalov
Proceeding from the fact that it is necessary to apply adaptive mechanics, and
from the fact that in the source code
Core
Issue Type: Bug
Components: Engine
Affects Versions: 3.0.3, 2.5.8
Reporter: Rashid Abzalov
create or alter procedure p1 (N integer) returns (R integer)
as
begin
R = N;
suspend;
end^
commit^
create or alter procedure p2 returns (S varchar(100
Issue Type: Improvement
Components: Engine, TRACEMGR
Affects Versions: 4.0 Beta 1
Reporter: Rashid Abzalov
Adding the ability to trace (using fbtrace) server access to system tables. Now
the use of system tables are not visible when tracing.
This feature will allow
URL: http://tracker.firebirdsql.org/browse/CORE-6013
Project: Firebird Core
Issue Type: Improvement
Components: API / Client Library
Affects Versions: 4.0 Beta 1
Reporter: Rashid Abzalov
Add the ability to specify in the isc_dsql_fetch
18 matches
Mail list logo