Linux Builds do not support TZ datatypes

[DaltonCalford]

The linux builds found on
http://ftp.de.debian.org/debian/pool/main/f/flamerobin/flamerobin_0.9.10.ds.2-1_amd64.deb

Which is maintained by Damyan Ivanov [email protected]

Has a problem with TZ datetime data.

Samples to reproduce
CREATE TABLE "Actions" ( "Time_Stamp" timestamp with time zone NOT NULL);
INSERT INTO "Actions" ("Time_Stamp") values ('2022-05-19 16:27:11.0000 +00:00')
SELECT a."Time_Stamp" FROM "stg.Actions" a

But casting the column as a varchar, works - so the database has the record but the client can not handle TZ data

[arvanus]

Hi, so, no idea how or when he will update to latest version, until that day, I recommend to you do use latest source code and build yourself
Also, for now keep in mind #338 and #362

[DaltonCalford]

Hi, so, no idea how or when he will update to latest version, until that day, I recommend to you do use latest source code and build yourself Also, for now keep in mind #338 and #362

I have tried to build flamerobin using the latest sources (see #359) but the docs are out of date and flamerobin will not build with the current wxwidgets on linux.

So the issue is that without proper build docs or a working build, it is not possible to use Flamerobin on linux with newer versions of firebird.

[DaltonCalford]

Hi, so, no idea how or when he will update to latest version, until that day, I recommend to you do use latest source code and build yourself Also, for now keep in mind #338 and #362

Just to note, he is building the latest 9.10 builds. He is keeping it up to date - the issue is a compatibility issue with the linux code in regards to holding TZ data in the app.
The ability to have the server cast it to varchar and get the data and have fbisql also query from the client shows the issue again is within the client application

[mariuz]

https://github.com/mariuz/flamerobin/wiki/How-to-Build-flamerobin-on-ubuntu-or-debian

…

On Thu, Feb 8, 2024 at 2:20 AM DaltonCalford ***@***.***> wrote: Hi, so, no idea how or when he will update to latest version, until that day, I recommend to you do use latest source code and build yourself Also, for now keep in mind #338 <#338> and #362 <#362> I have tried to build flamerobin using the latest sources (see #359 <#359>) but the docs are out of date and flamerobin will not build with the current wxwidgets on linux. So the issue is that without proper build docs or a working build, it is not possible to use Flamerobin on linux with newer versions of firebird. — Reply to this email directly, view it on GitHub <#368 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AAAEPN63X2FPH3DNPFUBMP3YSQK5HAVCNFSM6AAAAABC6BAFGKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMZTGE2TSMRTGU> . You are receiving this because you are subscribed to this thread.Message ID: ***@***.***>

[DaltonCalford]

https://github.com/mariuz/flamerobin/wiki/How-to-Build-flamerobin-on-ubuntu-or-debian
…
On Thu, Feb 8, 2024 at 2:20 AM DaltonCalford @.> wrote: Hi, so, no idea how or when he will update to latest version, until that day, I recommend to you do use latest source code and build yourself Also, for now keep in mind #338 <#338> and #362 <#362> I have tried to build flamerobin using the latest sources (see #359 <#359>) but the docs are out of date and flamerobin will not build with the current wxwidgets on linux. So the issue is that without proper build docs or a working build, it is not possible to use Flamerobin on linux with newer versions of firebird. — Reply to this email directly, view it on GitHub <#368 (comment)>, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAAEPN63X2FPH3DNPFUBMP3YSQK5HAVCNFSM6AAAAABC6BAFGKVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMYTSMZTGE2TSMRTGU . You are receiving this because you are subscribed to this thread.Message ID: @.>
-- The C compiler identification is GNU 13.2.0
-- The CXX compiler identification is GNU 13.2.0
-- Detecting C compiler ABI info
-- Detecting C compiler ABI info - done
-- Check for working C compiler: /usr/bin/cc - skipped
-- Detecting C compile features
-- Detecting C compile features - done
-- Detecting CXX compiler ABI info
-- Detecting CXX compiler ABI info - done
-- Check for working CXX compiler: /usr/bin/c++ - skipped
-- Detecting CXX compile features
-- Detecting CXX compile features - done
CMake Error at /usr/share/cmake-3.28/Modules/FindwxWidgets.cmake:235 (message):
wxWidgets wx/version.h file not found in
/usr/lib/x86_64-linux-gnu/wx/include/gtk3-unicode-3.2-unofficial;/usr/include/wx-3.2-unofficial.
Call Stack (most recent call first):
/usr/share/cmake-3.28/Modules/FindwxWidgets.cmake:966 (wx_extract_version)
CMakeLists.txt:44 (find_package)

this is with ubuntu 23.10, new install.
Jammy (22.04) has had three updates since (22.10, 23.04, 23.10) and wxwidgets has had issues for the past few.

The maintainer of the debs in the distribution Damyan Ivanov must have found a work around in the cmake but, even his builds of the latest code set, has issues with TZ data.

[mariuz]

Please see if this fixes the issue

https://flamerobin.blogspot.com/2023/05/problems-with-wx-config-from-codelites.html