[Firebird-devel] PostgreSQL vs. fsync error

2019-02-16 Thread Omacht AndrĂ¡s
Dear Developers, https://wiki.postgresql.org/wiki/Fsync_Errors Firebird can be also involved in the problem? Perodically we have corrupted databases on linux (85% wrong page type). And this cannot be reproduced for ages. Currently we are running FB 2.5.8 on 4.1.12 kernel. Thanks. Andras Fire

[Firebird-devel] The best strategy for altering of several table attributes

2019-02-16 Thread Dimitry Sibiryakov
Hello, All. I'm working on controlling of replication using SQL and get stuck on "alter table" statement. It may include zero or more clauses that require modification of RDB$RELATIONS table. For example: "alter table t drop sql security, disable replication". What is the best way to ha

Re: [Firebird-devel] Setting time zone bind through DPB?

2019-02-16 Thread Mark Rotteveel
On 16-2-2019 16:04, Dimitry Sibiryakov wrote: 16.02.2019 15:57, Mark Rotteveel wrote: I was wondering if it was considered to also set these options through the DPB. Especially for time zone support, I'm currently considering not supporting this for Java 7 in Jaybird, and it would save some he

Re: [Firebird-devel] Setting time zone bind through DPB?

2019-02-16 Thread Kovalenko Dmitry
> One question: how are you going to decide whether these DPB options must be set (server is 4.0) or not (server 3.0-)? Through protocol version. Dmitry Kovalenko. PS. Not ask me about fbclient.dll :) Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinf

Re: [Firebird-devel] Setting time zone bind through DPB?

2019-02-16 Thread Dimitry Sibiryakov
16.02.2019 15:57, Mark Rotteveel wrote: I was wondering if it was considered to also set these options through the DPB. Especially for time zone support, I'm currently considering not supporting this for Java 7 in Jaybird, and it would save some headaches if it were possible to control this thro

[Firebird-devel] Setting time zone bind through DPB?

2019-02-16 Thread Mark Rotteveel
Firebird 4 introduces statements SET TIME ZONE BIND to handle how the WITH TIME ZONE types are bound. I was wondering if it was considered to also set these options through the DPB. Especially for time zone support, I'm currently considering not supporting this for Java 7 in Jaybird, and it wo