firebird_fdw

firebird_fdw copied to clipboard

UUID support

4

Hello, @ibarwick! You have powerful inspired me for C FDW contributing. Some hours ago I have implemented [UUID support for sqlite_fdw](https://github.com/mkgrgis/sqlite_fdw/tree/draft_uuid) and check SQLite to Firebird data transport. Unfortunately there...

mkgrgis

limit rows returned

3

We use firebird_fdw to connect our postgres instance to a fairly large-sized firebird instance(s). When one of our users makes a query that calls a significantly-large dataset, the query will...

ablomeke

By https://github.com/pgspider/sqlite_fdw/blob/master/README.md inspired by https://github.com/ibarwick/firebird_fdw/blob/master/README.md ;-)

mkgrgis

Full test: ```SQL CREATE TABLE "AB" ("AB" int, "Ab" INT, "aB" INT, "ab" INT, "c" boolean); CREATE TABLE "aB" ("AB" int, "Ab" INT, "aB" INT, "ab" INT, "c" boolean); CREATE...

mkgrgis

Cannot load extension into PostgreSQL 15 and 14 - libfq-0.5.0.so

1

I tried to install the library on both version 14 and 15 on debian and ubuntu. I always get the same message `postgres=# create extension firebird_fdw; ERROR: could not load...

milocha

Feature request or discussion. I have found some examples * Firebird array IO operations https://github.com/FirebirdSQL/firebird/blob/master/examples/api/api10.c * PostgreSQL array IO operations https://stackoverflow.com/questions/20396546/create-simple-c-function-for-postgresql-with-array-input-and-array-output https://doxygen.postgresql.org/arrayfuncs_8c.html

mkgrgis

Cannot load extension into PostgreSQL 15 - undefined symbol: pg_atoi

6

https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=73508475d69e90f98ebd9b7e1a5933a26a49c5e9 has removed has removed pg_atoi As a result packaged firebird_fdw cannot be loaded into PostgreSQL 15: ``` postgres=# create extension firebird_fdw; ERROR: could not load library "/usr/pgsql-15/lib/firebird_fdw.so": /usr/pgsql-15/lib/firebird_fdw.so: undefined...

mithnae

IMPORT FOREIGN SCHEMA behaviour

6

This is not real issue, but discussion about `quote_identifiers` to continue https://github.com/ibarwick/firebird_fdw/issues/15#issuecomment-671018068. I think it will be simple for refactoring, if `IMPORT FOREIGN SCHEMA` behaviour with `LIMIT TO` and `EXCEPT`...

mkgrgis

Foreign server name quoting during IMPORT FOREIGN SCHEMA

1

- Firebird_fdw 1.3.0 - PostgreSQL 14 The name of server is `"fb テスト"`. Console output after `set client_min_messages='debug3';` ``` DEBUG: CREATE FOREIGN TABLE fbTest."ab" ( AB INTEGER, "Ab" INTEGER, "aB"...

mkgrgis

User survey - how and why do you you use firebird_fdw? And what features are missing?

2

Hi As the maintainer of `firebird_fdw`, I'd be very interested to know how and why people are using it. Answers to some or all of the following questions would be...

ibarwick