Re: [Firebird-devel] Firebird on Android + Delphi + Firedac - numerics issue
Did you try to fetch numerics using isql? i do not know how to run isql on Android Can you attach from your application to remote host? If yes what does happen with numerics in that case? I have tried without success. i have tried by TCP/IP over USB and also by WIFI. I always got "unavaiable database". Should i put copy of firebird.conf in same dir as client lib to support remote connections? I have firebird.conf configured only Providers = Engine12. But client library is in "\Firebird\lib\" and firebird.conf is above in "\Firebird\" regards, Karol Bieniaszewski -- 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/listinfo/firebird-devel
Re: [Firebird-devel] CORE-5877 Garbage in the compound index after several updates
Not exactly so. When index key is not changed by UPDATE statement, engine doesn't add it into the index. Ok, so it has not changed. tx1: insert record (r1) with index key (k1) >> table contains one record version: r1-tx1 >> index contains one entry: (k2, r1) tx1: commit tx2: update r1 set key = k2 >> table contains two records versions: r1-tx2, r1-tx1 >> index contains two entries: (k1, r1), (k2, r1) tx2: commit garbage collector: >> remove from disk r1-tx1, >> build lists: staying (r1-tx2), going (r1-tx1) >> going to cleanup indices >> context switch... >> table: r1-2 >> index: (k1, r1), (k2, r1) tx3: update r1 set key = k1 >> table: r1-tx3, r1-tx2 >> index: (k1, r1), (k2, r1) note, tx3 doesn't add index entry (k1, r1) as it is already present tx3: commit garbage collector: >> ...continue to cleanup indices >> lists: staying (r1-tx2), going (r1-tx1) >> keys: staying (k2), going (k1) >> remove index key (k1, r1) On disk >> table: r1-tx3, r1-tx2 >> index: (k2, r1) r1-tx3 contains key = k1, but index have no such entry Very informative, thank you very much. Above describe the problem, but how it was fixed after FB2 that we have now this issue? regards, Karol Bieniaszewski -- 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/listinfo/firebird-devel
Re: [Firebird-devel] [moved from support] LOCALTIME and LOCALTIMESTAMP
Hi, thank you for the link. If i understand correctly then all functions "CURRENT_..." and "LOCAL_..." result are in session TZ? If yes, then now it is much clearer, I thought that "CURRENT_" state for server time zone retrieved from e.g. system and "LOCAL_" was for database timezone or something like this. will be good if you provide some example in provided link. Something like this (if I have not mistaken something): old way FB3: SERVER TZ = "-02:00" CURRENT_TIMESTAMP will be "2018-07-18 23:00:00" CURRENT_TIME will be "23:00:00" CURRENT_DATE will be "2018-07-18" new way FB4: SERVER TZ = "-02:00" SESSION TZ = "+02:00" CURRENT_TIMESTAMP will be "2018-07-19 03:00:00 +02" CURRENT_TIME will be "03:00:00 +02" LOCAL_TIMESTAMP will be "2018-07-19 03:00:00" LOCAL_TIME will be "03:00:00" CURRENT_DATE will be "2018-07-19" One more question. How phisically are TZ info stored in field? Is field alwas written in GMT and do not require any more bytes in the database? And is converted to session timezone? regards, Karol Bieniaszewski -- 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/listinfo/firebird-devel
[Firebird-devel] [moved from support] LOCALTIME and LOCALTIMESTAMP
Hi, moved from support list as requested by Mark Rotteveel question about timezone support in FB4. How “current” timezone is configurred? Is it retrived from system or from Firebird config? I suppose that both configuration should be possible it will be more flexible. We then can have multiple FB installation on same server with different timezone settings. This is required especially for shared hostings. But if it can be set in firebird.conf then CURRENT_DATE is not enought to have. Should be also introduced LOCAL_DATE. Why? Because CURRENT_DATE will be different of CAST(LOCAL_TIMESTAMP AS DATE) if system time zone is different then in the config. regards, -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] [FB-Tracker] Closed: (CORE-5726) Unclear error message when inserting value exceeding max of dec_fixed decimal
There is no need for a new error, but a consistent error scheme should be applied, as already exists. this is what i wanted to say. By "new" - i have thinked, change for old as was chosen for new "big" numerics. BTW: Firebird 4 is not a point release, it is a major release. A point release is something like 2.5.8, which is a point release for Firebird 2.5. Yes, you have right (English is not my primary language) i have thinked point is 1, 2, 3, 4 not something after dot. regards, Karol Bieniaszewski --- Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie antywirusowe Avast. https://www.avast.com/antivirus -- 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/listinfo/firebird-devel
Re: [Firebird-devel] [FB-Tracker] Closed: (CORE-5726) Unclear error message when inserting value exceeding max of dec_fixed decimal
Hi, it is better to change all already errors to new one in new point release as FB4 is. As Mark say already, it should be not visible to the user that there is some difference between Numeric(18,2) and numeric(34,34)... All numerics should have same error messages. regards, Karol Bieniaszewski --- Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie antywirusowe Avast. https://www.avast.com/antivirus -- 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/listinfo/firebird-devel
[Firebird-devel] Tracker
Hi, will be good if tracker and any FB page do not show server details when it is off now it show something like this: “ Service Temporarily Unavailable The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later. Apache/2.2.3 (CentOS) Server at tracker.firebirdsql.org Port 80 ” which is very old version from year 2012 regards, Karol Bieniaszewski-- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] CORE-5343 and CORE-2557
Hi, by the same i mean ALTER ROLE EXISTING SET SYSTEM PRIVILEGES TO MONITOR_ANY_STATMENTS? or granting MONITOR_ANY_ATTACHMENT affect any MON$ tables? I need to have possibility to grant select on all attachemnts but i do not want that such user see all statements content. regards, Karol Bieniaszewski From: liviuslivius Sent: Wednesday, May 16, 2018 4:40 PM To: For discussion among Firebird Developers Subject: Re: [Firebird-devel] CORE-5343 and CORE-2557 Hi, Is the same for mon$statements and other mon tables? Regards, Karol Bieniaszewski -- 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/listinfo/firebird-devel -- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
[Firebird-devel] Fw: [firebird-support] Re: Mapping Windows group to FB role is not implemented?
Hi, i see in the source code https://github.com/FirebirdSQL/firebird/blob/0c75917d38016ab8674889534bf859af475a3ec9/src/auth/trusted/AuthSspi.cpp#L376that walking throught windows groups is not implemented? there is // ToDo: walk groups to which login belongs and list them using writerInterface regards, Karol Bieniaszewski From: 'livius' liviusliv...@poczta.onet.pl [firebird-support] Sent: Tuesday, March 27, 2018 8:05 PM To: firebird-supp...@yahoogroups.com Subject: [firebird-support] Re: Mapping Windows group to FB role Hi, anybody can help with - point 4? 1. enable windows authentication is working ok by CREATE GLOBAL MAPPING TRUSTED_AUTH USING PLUGIN WIN_SSPI FROM ANY USER TO USER; 2. mapping specific windows domain user to internal Firebird user is working ok by: CREATE MAPPING TRUSTED_KBIENIASZEWSKI USING PLUGIN WIN_SSPI FROM 'xCORP\KAROL.BIENIASZEWSKI' TO USER KBIENIASZEWSKI; 3. granting specific role to windows user inside databse is working ok by: grant WSZYSCY TO 'xCORP\KAROL.BIENIASZEWSKI' 4. mapping windows group to Firebird role is not working CREATE MAPPING TRUSTED_WSZYSCY USING PLUGIN WIN_SSPI FROM predefined_group 'rFirebird-Firebird-DBRido-ReadWrite' TO ROLE WSZYSCY; this also is not working CREATE MAPPING TRUSTED_WSZYSCY USING PLUGIN WIN_SSPI FROM predefined_group 'xCorp\rFirebird-Firebird-DBRido-ReadWrite' TO ROLE WSZYSCY; i am missing something obvious? regards, Karol Bieniaszewski >Hi, >can someone point me how can i map windows group to the Firebird role? >I have tried already >CREATE MAPPING TRUSTED_WSZYSCY USING PLUGIN WIN_SSPI FROM predefined_group >'rFirebird-Firebird-DBRido-ReadWrite' TO ROLE WSZYSCY >I have also tested with prefix xcorp\rFirebird... mapping was created but this >not work for me. >Can someone help? >Regards, >Karol Bieniaszewski --- Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie antywirusowe Avast. https://www.avast.com/antivirus [Non-text portions of this message have been removed] __._,_.___ -------- Posted by: "livius" <liviusliv...@poczta.onet.pl> Reply via web post • Reply to sender • Reply to group • Start a New Topic • Messages in this topic (2) Have you tried the highest rated email app? With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Visit Your Group a.. New Members 6 • Privacy • Unsubscribe • Terms of Use . __,_._,___-- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] RETURNING clause returning NULL row when no value was updated
I must say that i thinked about this in the same way as you. And i also do not know from where i got this impression ... I really supposed that it return resultset regards, Karol Bieniaszewski -Oryginalna wiadomość- From: Jiří Činčura Sent: Wednesday, November 29, 2017 1:32 PM To: firebird-devel@lists.sourceforge.net Subject: Re: [Firebird-devel] RETURNING clause returning NULL row when no value was updated "Update returning" is the same as "execute procedure". It returns fixed set of values, not a result set. Hmm. I lived in a dream. I would argue that the i.e. "update foobar set foo = 2 returning bar;" would return multiple rows and is allowed since 2.5. But quick test now shows that even 3.0.2 prohibits that. Not sure where I've got that impression from. I just can't get, at least once, helping hand from Firebird. :) -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ -- 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/listinfo/firebird-devel --- Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie antywirusowe Avast. https://www.avast.com/antivirus -- 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/listinfo/firebird-devel
[Firebird-devel] CORE-5634
Hi, i know that http://tracker.firebirdsql.org/browse/CORE-5634 is closed but it should be? Alexander Peshkov say there: “So yes, case is correctly always changed to upper case. “" but this is not true because attributes are not upper case only are Gid, Uid – as you can see it is not upper case. CREATE USER KBIENIASZEWSKI PASSWORD ‘XYZ’; commit; ALTER USER KBIENIASZEWSKI SET TAGS(UID=’2’, GID=’5’); commit; SELECT r.RDB$DB_KEY, r.SEC$USER_NAME, r.SEC$KEY, r.SEC$VALUE, r.SEC$PLUGIN FROM SEC$USER_ATTRIBUTES r 002c:0001KBIENIASZEWSKI Gid5 Legacy_UserManager <--- you see it is Gid not GID 002c:0002KBIENIASZEWSKI Uid2 Legacy_UserManager <--- you see it is Uid not UID and in the code there is e.g.: setAttr(attr, "Uid", >u); setAttr(attr, "Gid", >g); regards, Karol Bieniaszewski-- Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdotFirebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
Re: [Firebird-devel] [SPAM] Re: Build sources
Hi, thank you all for the answer and really detailed answer from you Vlad. I have finally successfully build it by VS 2015 Community Edition :) regards, Karol Bieniaszewski -Oryginalna wiadomość- From: Vlad Khorsun via Firebird-devel Sent: Friday, October 13, 2017 2:19 PM To: firebird-devel@lists.sourceforge.net Cc: Vlad Khorsun Subject: [Firebird-devel] [SPAM] Re: Build sources 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 see that for libtomcrypt is only MSVC12.sln. MSVC12 is kind of official compiler on Windows. MSVC14 build system is just updated. When i tried to compile it under ide i got that command line switches /ZI and /Gy are incompatibile. It was error in Win32\Debug project files, fixed. Is there some guide how to build FB from IDE? Or only possibility is build from command line and then run from the ide to debug? You need to use command line one time for the very first build for every platform (32- or 64-bit): 1. open command prompt and point it to the builds\win32 folder 2. You may wish to set FB_PROCESSOR_ARCHITECTURE to the AMD64 or x86 value. By default it will be set to the PROCESSOR_ARCHITECTURE value. It defines what platform will be built - 64 or 32 bit correspondingly. 3. run following - make_icu - make_boot - make_all (optional) 4. Now you may open builds\win32\msvc14\Firebird.sln in IDE and work as usual Note, build put binaries into temp\$(PlatformName)\$(Configuration)\firebird folder. For example: temp\x64\Debug\firebird for debug x64 build. If you want to debug\run firebird\utilities from IDE, you should put necessary .conf and security4.fdb files there. And, of course, add SYSDBA into security4.fdb. It is required to do once, after the first build. make_all copies all necessary files into output_$(Configuration) folder, this is more-or-less what you see in snapshot builds. VC14 produces a lot of the same warning C4595, you may ignore it until we fix it. 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 at https://lists.sourceforge.net/lists/listinfo/firebird-devel -- 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/listinfo/firebird-devel
Re: [Firebird-devel] FB4 fetches
Karol, I just can confirm that message reached the group. But right now have no time to deal with fetches problem, sorry. Thank you for response, i understand that not all requests can be processed and analyzed immediately and such answer that team is busy is enough regards, Karol Bieniaszewski -- 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/listinfo/firebird-devel
Re: [Firebird-devel] Firebird 4.0 Alpha 1 release is available for testing
Thank you for the answer great news :) regards, Karol Bieniaszewski -Oryginalna wiadomość- From: Dmitry Yemanov Sent: Friday, August 25, 2017 6:09 AM To: For discussion among Firebird Developers ; livius Subject: Re: [Firebird-devel] Firebird 4.0 Alpha 1 release is available for testing 24.08.2017 23:34, livius wrote: However i see that context limit is "the same" for the single query Is this really plan for Firebird4 or it is postponed? It will be removed in the next Alpha/Beta release. Dmitry -- 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/listinfo/firebird-devel
Re: [Firebird-devel] Firebird 4.0 Alpha 1 release is available for testing
Hi, first i must thank you for great work :) I really wait for frame in window funcion, longer indentifiers and bigger database page size. And i test this intensively. However i see that context limit is "the same" for the single query Is this really plan for Firebird4 or it is postponed? http://tracker.firebirdsql.org/browse/CORE-809 And if it is plan for it, it will be increassed/removed for single query also or only form procedures/triggers? regards, Karol Bieniaszewski -Oryginalna wiadomość- From: Dmitry Yemanov Sent: Thursday, August 24, 2017 10:11 AM To: For discussion among Firebird Developers Subject: [Firebird-devel] Firebird 4.0 Alpha 1 release is available for testing Firebird Project announces the first Alpha release of Firebird 4.0, the next major version of the Firebird relational database, which is now available for testing. This Alpha release arrives with an early preview of the features and improvements currently under development by the Firebird development team, as well as with countless bugfixes. Our users are appreciated giving it a try and providing feedback to this mailing list. Apparent bugs can be reported directly to the bugtracker. Alpha releases are not encouraged for production usage or any other goals that require a stable system. They are, however, recommended for those users who want to help in identifying issues and bottlenecks thus allowing to progress faster through the Beta/RC stages towards the final release. Please read the Release Notes carefully before installing and testing this Alpha release. Download page: http://www.firebirdsql.org/en/firebird-4-0-0-alpha1/ Release Notes: http://web.firebirdsql.org/downloads/prerelease/v40alpha1/Firebird-4.0.0_Alpha1-ReleaseNotes.pdf -- Dmitry Yemanov -- 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/listinfo/firebird-devel -- 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/listinfo/firebird-devel
Re: [Firebird-devel] Start transaction from base transaction
Maybe "Starting from"? regards, Karol Bieniaszewski -Oryginalna wiadomość- From: Leyne, Sean Sent: Tuesday, May 9, 2017 9:20 PM To: For discussion among Firebird Developers Subject: Re: [Firebird-devel] Start transaction from base transaction > >>> + | SNAPSHOT SHARING FROM > >> SNAPSHOT BASED ON > >> ? > >> > > Do you think with this words it's clear that the new transaction uses > > the same snapshot used in , instead of incorrectly saying that it > > will use as the snapshot for the new transaction? > > > > Thinking in these terms, I'm more inclined to adapt (renaming SHARING > > to > > SHARED) Vlad's syntax to: > > > > SET TRANSACTION ISOLATION LEVEL SNAPSHOT SHARED FROM > >For me both variants are OK :) Probably native english speakers could > offer > something better and less ambiguous. IMO, "BASED ON" would seem to me to be more 'natural' terminology. Sean -- 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/listinfo/firebird-devel --- Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie antywirusowe Avast. https://www.avast.com/antivirus -- 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/listinfo/firebird-devel
Re: [Firebird-devel] Start transaction from base transaction
>Yes, but we should avoid to write whole novels at SQL statements ;) Agree - but to fast chice is also not good > It have no sence (if i understand you :) ) Maybe, but it should be prohibited in code or designed to do not create wrong behavior You know if something is possible someone use it and i mean: base transaction transaction 2 share base transaction transaction 3 share base transaction and someone try transaction 4 share e.g. transaction 2 ;-) in this point it should share base or do not alow it but maybe heare are not any problem? regards, Karol Bieniaszewski -Oryginalna wiadomość- From: Vlad Khorsun Sent: Saturday, May 6, 2017 11:55 AM To: firebird-devel@lists.sourceforge.net Subject: Re: [Firebird-devel] Start transaction from base transaction 06.05.2017 11:47, livius wrote: > Hi, > > for me name is confusing - beacause here can be two cases: > 1. Snapshot transaction is shared Looks like wrong\incomplete definition, as > 2. only view of database from its start point is shared and any > modification > caused by base snapshot and any sharing transaction is not shared between > transactions. we speak about this one. > Name must specify real maining. Yes, but we should avoid to write whole novels at SQL statements ;) > And question araise - is it possible that shared transaction with share > from > base transaction also possible to be shared? (i do not know if you > understand me) It have no sence (if i understand you :) ) 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 at https://lists.sourceforge.net/lists/listinfo/firebird-devel --- Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie antywirusowe Avast. https://www.avast.com/antivirus -- 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/listinfo/firebird-devel
Re: [Firebird-devel] Start transaction from base transaction
Hi, for me name is confusing - beacause here can be two cases: 1. Snapshot transaction is shared 2. only view of database from its start point is shared and any modification caused by base snapshot and any sharing transaction is not shared between transactions. Name must specify real maining. And question araise - is it possible that shared transaction with share from base transaction also possible to be shared? (i do not know if you understand me) regards, Karol Bieniaszewski -Oryginalna wiadomość- From: Vlad Khorsun Sent: Friday, May 5, 2017 11:01 PM To: firebird-devel@lists.sourceforge.net Subject: Re: [Firebird-devel] Start transaction from base transaction 05.05.2017 21:10, Adriano dos Santos Fernandes wrote: > On 05/05/2017 14:43, Dmitry Yemanov wrote: >> 05.05.2017 20:01, Vlad Khorsun wrote: >>> %type snap_shot >>> snap_shot >>> : SNAPSHOT >>> | SNAPSHOT TABLE >>> | SNAPSHOT TABLE STABILITY >>> + | SNAPSHOT SHARING FROM >> SNAPSHOT BASED ON >> ? >> > Do you think with this words it's clear that the new transaction uses > the same snapshot used in , instead of incorrectly saying that it > will use as the snapshot for the new transaction? > > Thinking in these terms, I'm more inclined to adapt (renaming SHARING to > SHARED) Vlad's syntax to: > > SET TRANSACTION ISOLATION LEVEL SNAPSHOT SHARED FROM For me both variants are OK :) Probably native english speakers could offer something better and less ambiguous. Also, i offer to add additional rule for transaction which should export its snapshot data (it allows to avoid export by all transactions), something like: SET TRANSACTION ISOLATION LEVEL SNAPSHOT WITH SHARED SNAPSHOT Not sure i like it :) 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 at https://lists.sourceforge.net/lists/listinfo/firebird-devel --- Ta wiadomość została sprawdzona na obecność wirusów przez oprogramowanie antywirusowe Avast. https://www.avast.com/antivirus -- 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/listinfo/firebird-devel