Re: [Firebird-devel] Firebird 4 Install and replication

24.02.2021 09:52, Peter Gore wrote: database = D:\Users\Peter\Documents\FB4Data\FB4TEST.FDB {  log_directory = D:\Apps\FB4\FB4Test\chlog  log_archive_directory = D:\Apps\FB4\FB4Test\archlog  log_archive_timeout = 10 } database = D:\Users\Peter\Documents\FB4Data\FB4TESTReplica.FDB {  log_sou

Re: [Firebird-devel] Firebird 4 Install and replication

Hi Dimitry, Thank you for your assistance so far. I have got synchronous replication working fine but still no joy with asynchronous. Here's my Replication.conf database = D:\Users\Peter\Documents\FB4Data\FB4TEST.FDB { log_directory = D:\Apps\FB4\FB4Test\chlog log_archive_directory = D:\Apps\FB4

Re: [Firebird-devel] Change metadata domain from "DOUBLE PRECISION" to "BIGINT"

Yes I know that I can extract and copy, I'll export/import only as a last resource But I'm asking if anyone here tried to do what I'm asking for, and if had any problems with this "hack" On Tue, Feb 23, 2021 at 6:28 PM Ivan Přenosil wrote: > - create new empty database using sql scripts (if yo

Re: [Firebird-devel] Change metadata domain from "DOUBLE PRECISION" to "BIGINT"

- create new empty database using sql scripts (if you do not have them you can extract them from original db using ISQL -X) - copy data using some datapump tool Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Change metadata domain from "DOUBLE PRECISION" to "BIGINT"

Karol, > Why not standard way by creating new field copy data delete old and > rename? > > It can be slow operation, is it your conern to do not take production database > too long offline? If yes, you can speed up such process if you have access to > good hardware with a loot of RAM and do all i

Re: [Firebird-devel] Change metadata domain from "DOUBLE PRECISION" to "BIGINT"

On Tue, Feb 23, 2021 at 3:00 PM liviuslivius wrote: > Why not standard way by creating new field copy data delete old and > rename? > Hundreds of tables/SPs/Triggers using this domain (it's used domain in almost every table, multiple times per table) It can be slow operation, is it your conern t

Re: [Firebird-devel] Change metadata domain from "DOUBLE PRECISION" to "BIGINT"

Why not standard way by creating new field copy data delete old and rename? It can be slow operation, is it your conern to do not take production database too long offline? If yes, you can speed up such process if you have access to good hardware with a loot of RAM and do all in memory.I do not

Re: [Firebird-devel] POSITION on binary blobs

> SELECT POSITION(cast(ascii_char(1) AS BLOB SUB_TYPE BINARY), > CAST(x'0001' as blob sub_type binary)) FROM rdb$database; Nice. Thanks. It even looks like I don't need the first CAST. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://

[Firebird-devel] Change metadata domain from "DOUBLE PRECISION" to "BIGINT"

Hi, I have a 100Gb+ database that has a domain of data type "Double Precision" but used as integer (no decimals, just integer values), and was hoping to change it to bigint. I has thinking: if I backup the database and edit the fdk with a hex editor and change the domain information, the 3º char a

Re: [Firebird-devel] Firebird 4 Install and replication

On 23-02-2021 07:31, Peter Gore wrote: Good morning, I'm a long standing Firebird User since FB1.5! My interest in FB4 is primarily replication, which I have been unable to get working. I have also noticed some errors in the documentation that I note below. I have manually downloaded the 32bi

Re: [Firebird-devel] POSITION on binary blobs

On 23/02/2021 10:37, Jiří Činčura wrote: > Or maybe not. Any smart way to make something like this work? Maybe I just > don't see it. > > SELECT POSITION(CAST(CAST(1 AS SMALLINT) AS BLOB SUB_TYPE BINARY), > CAST(x'0001' as blob sub_type binary)) FROM rdb$database > > The `CAST(1 AS SMALLINT)` i

Re: [Firebird-devel] POSITION on binary blobs

On 23-02-2021 14:37, Jiří Činčura wrote: Or maybe not. Any smart way to make something like this work? Maybe I just don't see it. SELECT POSITION(CAST(CAST(1 AS SMALLINT) AS BLOB SUB_TYPE BINARY), CAST(x'0001' as blob sub_type binary)) FROM rdb$database The `CAST(1 AS SMALLINT)` is, at the mo

Re: [Firebird-devel] POSITION on binary blobs

Or maybe not. Any smart way to make something like this work? Maybe I just don't see it. SELECT POSITION(CAST(CAST(1 AS SMALLINT) AS BLOB SUB_TYPE BINARY), CAST(x'0001' as blob sub_type binary)) FROM rdb$database The `CAST(1 AS SMALLINT)` is, at the moment constant byte value I'm getting (henc

Re: [Firebird-devel] POSITION on binary blobs

Ah, there's my problem. With little bit of casting I think I can make it work. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 4 Install and replication

23.02.2021 12:30, Mark Rotteveel wrote: Dmitry, your push with the change was a bit messy Yes, I've noticed that :-( could you rebase before pushing if your local master diverges from the remote master. Forgot about that, sorry. Dmitry Firebird-Devel mailing list, web interface at htt

Re: [Firebird-devel] POSITION on binary blobs

On 2021-02-23 10:27, Jiří Činčura wrote: Hi *, is there a reason why POSITION does not work on binary blobs? I would expect something like `POSITION(blob, 0x1)` to work. Did you mean POSITION(blob, x'01'), because I wouldn't expect 0x1 (an integer literal) to work. In any case, the problem

Re: [Firebird-devel] Firebird 4 Install and replication

On 2021-02-23 07:48, Dmitry Yemanov wrote: 23.02.2021 09:31, Peter Gore wrote: I also ran all the necessary DDL statements and run GFIX as prescribed *GFIX - Doc anomaly 2* Release Notes I found empirically that Page 28           gfix -replica read-only should be            gfix -replica rea

[Firebird-devel] POSITION on binary blobs

Hi *, is there a reason why POSITION does not work on binary blobs? I would expect something like `POSITION(blob, 0x1)` to work. -- Mgr. Jiří Činčura https://www.tabsoverspaces.com/ Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Firebird 4 Install and replication

23.02.2021 11:57, Peter Gore wrote: Here's my new config database = D:\Users\Peter\Documents\FB4Data\FB4TEST.FDB {  log_directory = D:\Apps\FB4\FB4Test\chlog  log_archive_directory = D:\Apps\FB4\FB4Test\archlog  log_archive_timeout = 10  verbose_logging = true } database = D:\Users\Peter\Do

Re: [Firebird-devel] Firebird 4 Install and replication

Thanks Dimitry for the super fast response. Yes you were correct the paths were incorrect. I have corrected this and no longer get the error message. Its still not replicating though. Here's my new config database = D:\Users\Peter\Documents\FB4Data\FB4TEST.FDB { log_directory = D:\Apps\FB4\FB4T

Re: [Firebird-devel] LibreOffice Patch : Can't use System V semaphores in a sandboxed macOS process

> Not really https://github.com/FirebirdSQL/firebird/commit/6ec7a10aa3b772527320729b6c67d6bc83258d39= Paul Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-