10.07.2017 11:11, D. Kruise пишет:
...
I installed in the exe directory
FBclient.dll
firebird.msg
ib_util.dll
icudt52.dll
icuin52.dll
icuuc52.dll
Seems you missed icudt52l.dat. Also, make sure, you used 64-bit DLL's
And into subdir intl
fbintl.conf
fbintl.dll
And into subdir plugins
en
14.07.2017 11:01, Jiří Činčura wrote:
Hi *,
I have this fbtrace.conf file:
database
{
enabled = true
log_connections = true
log_statement_prepare = true
log_statement_start = true
log_statement_finish = true
time_threshold = 0
}
And I'm starting t
14.07.2017 11:02, Jiří Činčura wrote:
Hi *,
I realized the fbtrace.conf has new format in FB3. Is the old one still
supported (because that's what the .NET provider is currently using - I
was not expecting this to be change "just because we can")?
In FB3 we used same configuration files form
14.07.2017 11:26, Jiří Činčura wrote:
What Firebird account you used to run trace ?
I haven't specified any username/password. The command line I posted is
all I executed.
It uses your OS user name (i guess) and thus it can't trace sessions of other
users. Specify correct user credentia
14.07.2017 12:14, Jiří Činčura wrote:
It uses your OS user name (i guess) and thus it can't trace sessions
of other
users. Specify correct user credentials and it should work.
No luck. I tried both ".\fbsvcmgr service_mgr user sysdba password
masterkey action_trace_start trc_name ..." a
16.07.2017 12:59, Mark Rotteveel wrote:
Is there a way to programmatically detect a connection is using wire encryption
(eg in a monitoring table or the service API)?
I'm writing a test to check if Jaybird is correctly (not) using encryption depending on its connection properties, and I'd prefe
18.07.2017 21:55, Adriano dos Santos Fernandes wrote:
Hi!
We have HASH function that returns a 64 bit integer. The algorithm is
bad and the result too small for a hash.
I propose to extend the same function with a second parameter with the
algorithm name.
> When only one parameter is passed, th
18.08.2017 14:59, Jiří Činčura wrote:
Hi *,
I'm running 3.0.2 x64 SS (on Win 2016 (if it matters)) and I can
consistently get "internal Firebird consistency check (decompression
overran buffer (179), file: sqz.cpp line: 282)". Sometimes it's quick
sometimes it takes few minutes. Always this. Too
Ignore please
Vlad
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.n
18.08.2017 19:45, Jiří Činčura wrote:
Could you try latest snapshot build ?
Running it (3.0.3.32798) for about an hour now. So far so good.
Sounds good ;)
Send full memory dump to me, please. Or, better, reproducible test
case,
if it is possible.
I can only trigger it from o
06.09.2017 9:45, Jiří Činčura wrote:
Hi *,
I was searching the tracker but couldn't find anything. Any plans around
supporting cross and outer apply "joins"?
I think we should consider standard LATERAL JOIN.
It seems not too hard to implement.
Regards,
Vlad
---
08.09.2017 11:03, Dmitry Yemanov wrote:
All,
The key point of this standard feature is to allow sub-queries to reference
priorly defined contexts (in joins).
While thinking about this, I have a few questions to raise here. The standard defines LATERAL for derived tables only. This sounds
logi
Test 2
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/li
11.10.2017 16:59, Dimitry Sibiryakov пишет:
10.10.2017 18:00, Dimitry Sibiryakov wrote:
I'd suggest to offer to the application developer third, more convenient,
option: subj.
If database connection string is used this way, server can automatically set the database name to expected_db and
10.10.2017 19:00, Dimitry Sibiryakov wrote:
Hello.
Imagine that you are an application developer and develop an application that allow users to enter connection string for database
they want to work with. Imagine that in new version of the application you would like to add some work with
11.10.2017 21:09, Dimitry Sibiryakov wrote:
11.10.2017 19:47, Vlad Khorsun via Firebird-devel wrote:
I don't see it as a problem, as user already should understand what is
connection string and
how to construct is from host name and database name. From my expirience
"usual&quo
11.10.2017 21:34, Adriano dos Santos Fernandes wrote:
I must agree that host:service_mgr is weird, but not all services
expects (or would expect) a database.
Can't say it is weird. Probably, we could allow to skip service manager
name, but it will be hard to specify XNET protocol without it.
11.10.2017 22:22, Dimitry Sibiryakov wrote:
11.10.2017 20:57, Vlad Khorsun via Firebird-devel wrote:
I don't understand your speculations
Ok, turn your imagination on: Performance of gbak must be improved by feeding of backup stream from server using services instead
of sending qu
11.10.2017 23:33, Dimitry Sibiryakov wrote:
11.10.2017 22:14, Vlad Khorsun via Firebird-devel wrote:
IIRC, it is already implemented.
No. This functionality is in fbsvcmgr, but not in gbak.
It is implemented at Service API level, i.e. by all the providers (engine,
remote, etc)
but
12.10.2017 0:37, Dimitry Sibiryakov wrote:
11.10.2017 22:56, Vlad Khorsun via Firebird-devel wrote:
The problem is that you don't undestand that auth parameters (required to
create
connection) should not be mixed with action's parameters.
I can't understand what yo
12.09.2017 15:33, Adriano dos Santos Fernandes wrote:
On 12/09/2017 08:46, Magnus Johansson wrote:
...
SELECT FIELD_UTF_SV_CI_NUM
FROM TABLE_T
WHERE FIELD_UTF_SV_CI_NUM BETWEEN '' AND 'b'
ORDER BY 1;
FIELD_UTF_SV_CI_NUM
===
1
2
10
20
a
A
aa
Aa
AA
b
===
13.10.2017 12:16, liviuslivius wrote:
Hi,
I try to build Fb master from sources.
What is the recommended environment for Windows. Can i use MSVC14 Express?
I never used Express version by myself. I use VS 2015 Community Edition
currently
for testing VC14 builds.
Or it must be MSVC12? I se
27.11.2017 16:50, Jiří Činčura wrote:
But mostly wierd is that even in theory crypt plugin can not affect
integrity constraints - encryption works a few logical levels deeper
than constraints violation, that's absolutely different parts of code.
Yeah. I though the database was somewhat corrupt
05.12.2017 0:40, William L. Thomson Jr. wrote:
On Sat, 2 Dec 2017 19:45:19 +0300
Egor Pugin wrote:
Hi,
See this PR https://github.com/FirebirdSQL/firebird/pull/133
which fixes all present issues for Windows and Ubuntu (possibly other
linux systems too).
Macos build is needed in additional fix
07.12.2017 16:23, Jiří Činčura wrote:
Hi *,
I'm getting, for quite some time, "Database is probably already opened
by another engine instance in another Windows session" on servers (2x
2.5.7, 1x 3.0.3 (although it's less common here)). The problem is, that
the database is only accessed via TCP/I
07.12.2017 17:16, Jiří Činčura wrote:
Nope. Still happening. Even with `-i`.
Hmm... i was not attentive enough, error is about database not about listener.
It means that one engine instance is already open database and another
instance
going to open it too and both instances runs in diffe
07.12.2017 19:15, Jiří Činčura wrote:
For example, one instance run in user session (for ex. embedded
connection)
and second instance run as a service.
That was original idea for hunting - disabling that somehow and then
waiting where something breaks. I'm at least blindly trying to fin
07.12.2017 20:02, Jiří Činčura wrote:
This is very strange. Does it put corresponding message into
firebird.log ?
If yes - how exactly it looks ?
Cannot initialize the shared memory region
Database is probably already opened by another engine instance
in another
12.12.2017 17:38, Gabor Boros wrote:
If the problem can't be reproduces with a simple database and simple
application, it's probably another problem.
I have a simple application and three databases. Can I send to you privately? I attached earlier but got a message about the 40 KB
body limit.
12.12.2017 19:55, Gabor Boros wrote:
2017. 12. 12. 18:31 keltezéssel, Vlad Khorsun via Firebird-devel írta:
12.12.2017 17:38, Gabor Boros wrote:
If the problem can't be reproduces with a simple database and simple
application, it's probably another problem.
I have a simple appli
15.12.2017 10:45, liviuslivius wrote:
Hi Vlad,
"This temporary blobs could be released on commit (rollback) only"
just curious, why it can not be released after it is used?
When its become unused ? That blobs returned to the client aplication
and should be accessible until transaction end.
15.12.2017 11:20, Adriano dos Santos Fernandes пишет:
On 15/12/2017 07:03, Vlad Khorsun via Firebird-devel wrote:
15.12.2017 10:45, liviuslivius wrote:
Hi Vlad,
"This temporary blobs could be released on commit (rollback) only"
just curious, why it can not be released after
15.12.2017 12:34, Dimitry Sibiryakov wrote:
15.12.2017 10:03, Vlad Khorsun via Firebird-devel wrote:
PS In theory, it should be possible to postpone transliteration into
attachment charset until application opens blob. But i see no easy\direct
way to do it.
In theory it is possible to
17.12.2017 17:33, Jiří Činčura wrote:
I.e. it is failed to initialize shared memory for monitoring snapshot.
I can't explain how it is possible to initialize lock manager shared
memory
first and then fail to initialize shared memory for monitoring snapshot.
Need more time to investigate it.
18.12.2017 14:26, Jiří Činčura wrote:
Right now I isolated the databases, so only apps from the same session
(0) are accessing the database and always via TCP/IP. I'm afraid it's
something else.
I found one change in v3 not backported into v2.5 which could be
related to this issue. Could you
20.12.2017 11:16, Jiří Činčura wrote:
v3 after you isolated the databases (what do you mean by this, btw) ?
I'm keeping eye on v3. For sure it's not often. But I think I saw it even on 3
before. Will wait a week or so to see whether it happens or not.
Isolated: I went through all apps and mad
26.12.2017 11:45, Jiří Činčura wrote:
Looks like the issue is not happening in nightly 3.0.3 (about two weeks old).
Good to know, thanks. Meanwile, i'm trying to reproduce it on v2.5.8 using
test
case from CORE-4680. No luck so far.
Regards,
Vlad
---
26.12.2017 16:48, Vlad Khorsun via Firebird-devel wrote:
26.12.2017 11:45, Jiří Činčura wrote:
Looks like the issue is not happening in nightly 3.0.3 (about two weeks old).
Good to know, thanks. Meanwile, i'm trying to reproduce it on v2.5.8 using
test
case from CORE-4680. No luck s
03.01.2018 7:57, Lionel Elie Mamane wrote:
I'd like to avoid completely parsing the SQL statement for that,
mainly so that the SQL statement is not modified by the LibreOffice
SQL parser (and in particular quoting keywords it doesn't know as
identifiers). So I'm hoping to simply go through the s
08.01.2018 15:52, Mark Rotteveel wrote:
I'm really out of my depth here. I've created a full dump of the Firebird
process while Jaybird is hanging:
https://www.dropbox.com/s/ea1fskiqtg1fmxs/fb_4build840_hang.7z?dl=0
Windows 10 x64, Firebird 4.0.0.840-0_x64
Does this provide helpful informati
09.01.2018 11:41, Mark Rotteveel wrote:
On 8-1-2018 15:12, Vlad Khorsun via Firebird-devel wrote:
08.01.2018 15:52, Mark Rotteveel wrote:
I'm really out of my depth here. I've created a full dump of the Firebird
process while Jaybird is hanging:
https://www.dropbox.com/s/ea1fs
09.01.2018 13:38, Dimitry Sibiryakov wrote:
09.01.2018 12:21, Vlad Khorsun (JIRA) wrote:
Actually, isql connects successfully, but it reads RDB$DATABASE itself right
after attachment (using READ COMMITTED NO RECORD
VERSION WAIT transaction)
Shouldn't it be changed as well?
For what ?
18.01.2018 13:10, Dimitry Sibiryakov wrote:
18.01.2018 11:57, Dmitry Yemanov wrote:
IMO, no sane person would rely on that intentionally.
Why? This is the only method to get procedure compilation time, AFAIR.
Time of CREATE and last ALTER of SP\Trigger\etc should be stored in system
ca
19.01.2018 11:41, Adriano dos Santos Fernandes wrote:
On 19/01/2018 07:14, Roman Simakov wrote:
Hello!
It seems that we have a problem with installation of Firebird 3 on
OpenSuse. I get "Could not find acceptable ICU library".
I took a look into sources. FB tries to search ICU modules in some
27.12.2017 0:38, Vlad Khorsun via Firebird-devel wrote:
26.12.2017 16:48, Vlad Khorsun via Firebird-devel wrote:
26.12.2017 11:45, Jiří Činčura wrote:
Looks like the issue is not happening in nightly 3.0.3 (about two weeks old).
Good to know, thanks. Meanwile, i'm trying to reprodu
28.01.2018 10:44, Jiří Činčura wrote:
Sadly it has happened again few hours ago. 2.5.8 x64, running on Windows Server.
Sad. I'll backport shared memory initialization from v3
Regards,
Vlad
--
Check out the vibrant t
07.02.2018 12:55, Mark Rotteveel wrote:
Someone reported a crash on shutdown of Firebird 2.5.8 Embedded in a C# application on stack overflow:
https://stackoverflow.com/questions/48644878/appcrash-in-fbintl-dll-if-using-embedded-mode-in-my-c-app.
I can reproduce it with the provided example app
07.02.2018 13:26, Mark Rotteveel wrote:
On 7-2-2018 11:55, Mark Rotteveel wrote:
Someone reported a crash on shutdown of Firebird 2.5.8 Embedded in a C# application on stack overflow:
https://stackoverflow.com/questions/48644878/appcrash-in-fbintl-dll-if-using-embedded-mode-in-my-c-app.
I can
07.02.2018 14:17, Mark Rotteveel пишет:
On 7-2-2018 12:36, Vlad Khorsun via Firebird-devel wrote:
07.02.2018 13:26, Mark Rotteveel wrote:
On 7-2-2018 11:55, Mark Rotteveel wrote:
Someone reported a crash on shutdown of Firebird 2.5.8 Embedded in a C# application on stack overflow:
https
07.02.2018 14:41, Mark Rotteveel wrote:
On 7-2-2018 12:36, Vlad Khorsun via Firebird-devel wrote:
07.02.2018 13:26, Mark Rotteveel wrote:
On 7-2-2018 11:55, Mark Rotteveel wrote:
Shouldn't the engine be able to cope with this?
Yes, and fb_shutdown handle it. But it can't
07.02.2018 15:21, Mark Rotteveel wrote:
On 7-2-2018 13:54, Vlad Khorsun via Firebird-devel wrote:
07.02.2018 14:41, Mark Rotteveel wrote:
On 7-2-2018 12:36, Vlad Khorsun via Firebird-devel wrote:
07.02.2018 13:26, Mark Rotteveel wrote:
On 7-2-2018 11:55, Mark Rotteveel wrote:
Shouldn'
20.02.2018 14:23, Rashid Abzalov wrote:
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?
I have the same understanding
If not, is it p
Looking at bug CORE-5774 i found very odd behavior of engine: it seems it
rebuilds
indices in many unneeded cases, when almost any property of the indexed field
is changed.
I understand that index should be rebuild in this cases only:
- field data type is changed *and* its "index" type cha
19.03.2018 11:55, Leyne, Sean wrote:
Vlad,
Looking at bug CORE-5774 i found very odd behavior of engine: it seems it
rebuilds indices in many unneeded cases, when almost any property of the
indexed field is changed.
I understand that index should be rebuild in this cases only:
(1) - fi
19.03.2018 12:21, Leyne, Sean wrote:
And, probably, we should add:
(3) - NOT NULL is set and default value was set before
Really, why?
I don't see that as a change that would affect the existing index values.
The question was about existing NULL values. After i tried it i see that
NOT N
And, probably, we should add:
(3) - NOT NULL is set and default value was set before
Really, why?
I don't see that as a change that would affect the existing index values.
The question was about existing NULL values. After i tried it i see that NOT
NULL will not be set in this case:
SQL>
22.03.2018 13:21, marius adrian popa wrote:
sed part worked :)
now another one
https://travis-ci.org/mariuz/firebird/jobs/356795126
/Users/travis/build/mariuz/firebird/src/remote/../remote/SockAddr.h:101:2:
error: Unknown value of AF_INET6 !
#error Unknown value of AF_INET6 !
Should be fi
23.03.2018 16:05, Jiří Činčura wrote:
Hi *,
what's the expected path to take when I want to execute user provided statement in the same context (connection and transaction) in external engine? Do I have to go through IExternalContext etc.
If you ask about "expected path" - yes, you shoud us
26.03.2018 18:49, Jiří Činčura wrote:
Hmm, found `context->getMaster()->getConfigManager()->getRootDirectory()`. Is
there a better/shorter way?
This is the best way, especially if there could be more than one fbclient.dll
loaded by host process.
And adding "fbclient.dll" is then trivial.
10.04.2018 21:51, Rashid Abzalov wrote:
The implemented feature allows changing user indexes to any users.
It allows to change user indices by the OWNERS and users with ALTER TABLE
privilege granted, see below:
fb30\temp\x64\debug\firebird>isql s:\Temp\A.30.FDB
Database: s:\Temp\A.30.FDB, Us
Jorge,
Avoid over quoting, please
Regards,
Vlad
--
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
Firebird-Devel mailing list, web interface
30.04.2018 5:50, Adriano dos Santos Fernandes wrote:
Hi!
Time zones branch is almost feature complete.
There is two important subjects left:
- ICU in Windows - as I already said, it need to be upgraded and I would
like it builded as the upstream does, i.e., with full data. It would be
good if
10.05.2018 19:02, Adriano dos Santos Fernandes wrote:
On 10/05/2018 12:53, Lester Caine wrote:
...
And how will the version of TZ data be handled! This is a key element
that has screwed normalized data in the past, and some way to manage
that normalized data needs to be included in the process.
10.05.2018 19:02, Adriano dos Santos Fernandes wrote:
On 10/05/2018 12:53, Lester Caine wrote:
...
And how will the version of TZ data be handled! This is a key element
that has screwed normalized data in the past, and some way to manage
that normalized data needs to be included in the process.
10.05.2018 19:23, Adriano dos Santos Fernandes wrote:
On 10/05/2018 13:12, Vlad Khorsun via Firebird-devel wrote:
I guess the question is about the case when users have historical data
and need to apply old time zone rule to the old data and new timezone
rule
to the new data.
Is it
10.05.2018 19:57, Adriano dos Santos Fernandes пишет:
On 10/05/2018 13:47, Vlad Khorsun via Firebird-devel wrote:
10.05.2018 19:23, Adriano dos Santos Fernandes wrote:
On 10/05/2018 13:12, Vlad Khorsun via Firebird-devel wrote:
I guess the question is about the case when users have
10.05.2018 20:29, Adriano dos Santos Fernandes пишет:
On 10/05/2018 14:23, Vlad Khorsun via Firebird-devel wrote:
Look how MSK time zone was changed at 2014.10.26
https://www.timeanddate.com/time/zone/russia/moscow
I think about something like this:
ID Name Valid from
10.05.2018 21:13, Lester Caine wrote:
On 10/05/18 18:47, Vlad Khorsun via Firebird-devel wrote:
Regions that use Daylight Saving Time (DST) change the time zone name and time during the DST period. The words “daylight” or
“summer” are then usually included in the time zone name. The areas that
10.05.2018 21:21, Adriano dos Santos Fernandes wrote:
The name for Moskow is Europe/Moscow.
Please, convert to UTC and explain how to do it:
2010.03.01 04:00 Europe/Moscow,
2013.03.01 04:00 Europe/Moscow,
2016.03.01 04:00 Europe/Moscow
Regards,
Vlad
--
10.05.2018 22:08, Adriano dos Santos Fernandes wrote:
On 10/05/2018 15:30, Vlad Khorsun via Firebird-devel wrote:
The key is that DST doesn't affect given time zone. TZ could be
"standard time" based (such as MSK)
or "DST based" (such as MSD or IST you speak ab
11.05.2018 1:27, Adriano dos Santos Fernandes wrote:
On 10/05/2018 18:03, Vlad Khorsun via Firebird-devel wrote:
...
Could you answer my question below ?
Please, convert to UTC and explain how to do it:
2010.03.01 04:00 Europe/Moscow,
2013.03.01 04:00 Europe/Moscow,
2016.03.01
12.05.2018 1:12, Lester Caine wrote:
On 11/05/18 20:37, Adriano dos Santos Fernandes wrote:
* PST is Pitcairn or Pacific, with the same offset, they are
considered different time zones
ICU data is derived from TZ data hosted by IANA
(http://site.icu-project.org/tznotice).
I really can't answe
14.05.2018 10:13, Simonov Denis via Firebird-devel wrote:
I'm wondering how the time zones will be updated?
See "Updating the Time Zone Data" at
http://userguide.icu-project.org/datetime/timezone
Will they be distributed as a separate file in Firebird?
So far i see no need for
10.05.2018 19:23, Adriano dos Santos Fernandes wrote:
On 10/05/2018 13:12, Vlad Khorsun via Firebird-devel wrote:
I guess the question is about the case when users have historical data
and need to apply old time zone rule to the old data and new timezone
rule
to the new data.
Is it
18.05.2018 11:00, Jiří Činčura wrote:
Hi *,
what could be the reason for "Missing master config file firebird.conf" mesage when doing
".\firebird.exe -a"? I'm traying to start Firebird on AAppVeyor for tests for
NETProvider. When I execute it manually it starts fine. Only when from script from
All,
I going to merge into master implementation of pool of external connections.
The feature was initially developed more than a year ago, and works at
production
with good feedback.
Some bugs was fixed since then, so it should be stable enough and definitely
good for beta release of v4.
18.05.2018 21:19, Dimitry Sibiryakov wrote:
18.05.2018 18:44, Vlad Khorsun via Firebird-devel wrote:
Please, read and comment:
Is the connection pool an "engine thing" or it is at server/Y-valve level?
Whole EDS feature is implemented as part of engine.
Isn't pas
18.05.2018 22:15, Dimitry Sibiryakov wrote:
18.05.2018 20:49, Vlad Khorsun via Firebird-devel wrote:
Whole EDS feature is implemented as part of engine.
Shouldn't new configuration parameters to be in the right place for plugin's parameters: engine13.conf instead of l
19.05.2018 11:04, Mark Rotteveel wrote:
On 18-5-2018 18:44, Vlad Khorsun via Firebird-devel wrote:
...
Please, read and comment:
https://github.com/FirebirdSQL/firebird/blob/ExternalConnectionsPool/doc/sql.extensions/README.external_connections_pool
1. I'm not sure how I should rea
19.05.2018 13:08, Mark Rotteveel wrote:
If it is global, then the permission for ALTER EXTERNAL CONNECTIONS POOL needs
to be changed:
"""
New SQL statement is introduced to manage the pool :
ALTER EXTERNAL CONNECTIONS POOL.
When prepared it desribed as DDL statement but have immed
19.05.2018 18:52, Dimitry Sibiryakov wrote:
>>Also, i want to speak about possible extension of the feature. I think it
would
>> be good to have new monitoring table with list of all external connections.
Not
>> sure if we should allow to DELETE here but it should be at least considered
to
19.05.2018 19:38, Dimitry Sibiryakov wrote:
BTW, what behavior is expected from GTT ON COMMIT PRESERVE in pooled
connection?
Nothing special was done in this area - GTT contents will be preserved.
The same for context variables.
So, we have a question - should we clear session-level s
19.05.2018 19:42, Dimitry Sibiryakov wrote:
"SET ROLE" statement issued in EDS is not handled in any way, right?
Yes
Regards,
Vlad
--
Check out the vibrant tech community on one of the world's most
engaging tech
20.05.2018 12:55, Mark Rotteveel wrote:
On 19-5-2018 17:11, Vlad Khorsun via Firebird-devel wrote:
19.05.2018 13:08, Mark Rotteveel wrote:
2. Fine-grained privilege that applies only to this single option: ALTER_EXTERNAL_CONNECTIONS_POOL or if shorter is preferred:
ALTER_EXT_CONN_POOL
3. In
20.05.2018 12:38, Dimitry Sibiryakov wrote:
19.05.2018 18:44, Vlad Khorsun via Firebird-devel wrote:
Nothing special was done in this area - GTT contents will be preserved.
The same for context variables.
So, we have a question - should we clear session-level state when connection
become
20.05.2018 14:06, Mark Rotteveel wrote:
On 20-5-2018 12:47, Vlad Khorsun via Firebird-devel wrote:
20.05.2018 12:55, Mark Rotteveel wrote:
On 19-5-2018 17:11, Vlad Khorsun via Firebird-devel wrote:
19.05.2018 13:08, Mark Rotteveel wrote:
2. Fine-grained privilege that applies only to this
20.05.2018 14:13, Dimitry Sibiryakov пишет:
20.05.2018 13:00, Vlad Khorsun via Firebird-devel wrote:
I'd suggest to add to EDS an option to use "isolated" connection, which is guaranteed the connection to be new and after use
to be deleted, not returned to pool.
Why one
20.05.2018 14:15, Mark Rotteveel wrote:
On 20-5-2018 13:00, Vlad Khorsun via Firebird-devel wrote:
I plan to introduce new database object "EXTERNAL DATA SOURCE" since initial
implementation of EXECUTE STATEMENT ON EXTERNAL, but I never have time\priority
to implement it, unf
20.05.2018 17:53, Dimitry Sibiryakov wrote:
20.05.2018 16:25, Adriano dos Santos Fernandes wrote:
Isn't (some parts of) the config file already reloaded sometimes (timeout)?
Firebird.conf is reloaded when its timestamp changed. Plugins' configs are
not reloaded.
Where do you see it ? I
20.05.2018 14:11, liviuslivius wrote:
Hi,
can i ask why this is only for external connections? 2 databases. One user run execute statement on database 1 from 2 second on
database 2 from 1. Third connect simply to database 1 why it can not benefit from pool?
Explain, please. The statement ab
20.05.2018 19:14, Dimitry Sibiryakov wrote:
20.05.2018 17:29, Vlad Khorsun via Firebird-devel wrote:
Where do you see it ?
You are right, it is nowhere in main tree. Sorry, I missed it up with one of
my branches.
In any case it is easy to add cache object to ConfigImpl constructor
21.05.2018 11:47, Dimitry Sibiryakov wrote:
21.05.2018 10:13, Mark Rotteveel wrote:
if pool contain connection to database 1
and user try to connect to also database 1 he can use pool instead normal
connection.
That wouldn't really work
Yes, that wouldn't work. But generally speaking p
21.05.2018 14:25, Rashid Abzalov wrote:
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 manag
21.05.2018 14:58, Rashid Abzalov wrote:
21.05.2018 14:42, Vlad Khorsun via Firebird-devel wrote:
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.
You see - all approaches hav
18.05.2018 19:44, Vlad Khorsun via Firebird-devel wrote:
All,
I going to merge into master implementation of pool of external connections.
The feature was initially developed more than a year ago, and works at
production
with good feedback.
According to discussion in this topic i
23.05.2018 12:32, Dimitry Sibiryakov wrote:
23.05.2018 11:24, Vlad Khorsun via Firebird-devel wrote:
- At tracker there was proposition to add new database trigger ON RESET which
should
fire when ALTER SESSION RESET is run. Should we implement it ?
What useful could such trigger do
23.05.2018 12:58, Dmitry Yemanov wrote:
23.05.2018 12:39, Vlad Khorsun wrote:
What useful could such trigger do?
I suppose - the most of the thing that users do on CONNECT (init some context variables, for example) and DISCONNECT (free some
resources).
Wouldn't it make sense to call ON
23.05.2018 13:40, Adriano dos Santos Fernandes wrote:
On 23/05/2018 06:48, Dimitry Sibiryakov wrote:
In this case I guess there must be two triggers: BEFORE RESET and
AFTER RESET.
I like this more than the other approaches.
I strongly suggest to consider existing DISCONNECT\CONNECT tri
23.05.2018 13:48, Mark Rotteveel wrote:
On 23-5-2018 11:24, Vlad Khorsun via Firebird-devel wrote:
18.05.2018 19:44, Vlad Khorsun via Firebird-devel wrote:
All,
I going to merge into master implementation of pool of external connections.
The feature was initially developed more than a
23.05.2018 15:40, Mark Rotteveel wrote:
- New session management statement ALTER SESSION RESET is implemented (see
CORE-5832).
Ticket is not marked as closed for a while as i want to make sure
implementation
is complete. Thus any suggestions, notes, etc are welcome.
As I said in anothe
1 - 100 of 121 matches
Mail list logo
