search

ibarwick / firebird_fdw

A PostgreSQL foreign data wrapper (FDW) for Firebird - latest version 1.4.0 (2024-05-11)
https://sql-info.de/postgresql/firebird-fdw/index.html
Other
36 stars 8 forks source link

Foreign server name quoting during IMPORT FOREIGN SCHEMA #31

Open mkgrgis opened 1 year ago

mkgrgis commented 1 year ago

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" INTEGER OPTIONS (quote_identifier 'true'),
    "ab" INTEGER OPTIONS (quote_identifier 'true'),
    "c" BOOLEAN OPTIONS (quote_identifier 'true')
) SERVER fb テスト
OPTIONS(
    quote_identifier 'true'
)
DEBUG:  entering function fb_xact_callback
DEBUG:  closing remote transaction on connection 0x563c60e00a10
DEBUG:  ROLLBACK
DEBUG:  leaving fb_xact_callback()
ERROR: syntax (near: "テスト")
行 7: ) SERVER fb テスト
                  ^
QUERY:  CREATE FOREIGN TABLE fbTest.AB (
    AB INTEGER,
    "Ab" INTEGER,
    "aB" INTEGER OPTIONS (quote_identifier 'true'),
    "ab" INTEGER OPTIONS (quote_identifier 'true'),
    "c" BOOLEAN OPTIONS (quote_identifier 'true')
) SERVER fb テスト
mkgrgis commented 1 year ago

Fixed by https://github.com/ibarwick/firebird_fdw/pull/37