Михаил
Михаил
> Please describe how you use firebird_fdw. For access to legacy industrial DBs (1990th) and for school students for RDBMS studies. For industrial DBs is very important to call FB's...
In some cases `pg_strtoint64(s)` can works in place of `pg_atoi`, see. https://github.com/petere/pguint/pull/21/files
Hello, @milocha ! Please read INSTALL-debian-ubuntu.md and carefully read https://github.com/ibarwick/libfq/pull/5 Please add your opinion to this discussion at the link.
Thanks, @ibarwick ! `CHAR(16) CHARACTER SET OCTETS` works fine. This look like `BLOB` affinity with 16 bytes in SQLite or Oracle `RAW(16)`. In all this cases we have 1⇔1 transformation...
Ping, @ibarwick ! My [PR with UUID support in SQLite-FDW](https://github.com/pgspider/sqlite_fdw/commit/d6387a8ea33129d69c45389ee20180d809a03f03) was merged. Thanks for inspiration! How can I help you here? Maybe test something about text transformation, see [previous message](https://github.com/ibarwick/firebird_fdw/issues/42#issuecomment-1685909952)?
Ping, @ibarwick . After https://github.com/pgspider/sqlite_fdw/commit/a272452097d6997ac7f44baa70b5b627450f3ded in `sqlite_fdw` there is full and unified support of both text and binary UUIDs against all supported PostgreSQL versions. How can I help you with...
Yes, there is an irreparable conflict between recommended ISO SQL behaviour and real PosgtreSQL+Firebird transformation of object names without quoting. > the general behaviour of firebird_fdw must be respected as...
For cases: Upper Lower Mixed we have this transformation table ``` Fb quote_identifiers Pg U f L L f n/a M f M U t U L t L M...
There is a bug: Firebird: ``` CREATE TABLE "AB" ("AB" int, "Ab" INT, "aB" INT, "ab" INT, "c" boolean); CREATE TABLE "aB" ("AB" int, "Ab" INT, "aB" INT, "ab" INT,...
@ibarwick, have you got any time for tests around of previous comment https://github.com/ibarwick/firebird_fdw/issues/17#issuecomment-1035878298 ? There is debug output [DEBUG.log](https://github.com/ibarwick/firebird_fdw/files/10320947/DEBUG.log) for my test.