firebird_fdw icon indicating copy to clipboard operation
firebird_fdw copied to clipboard

Foreign server name quoting during IMPORT FOREIGN SCHEMA

Open mkgrgis opened this issue 2 years ago • 1 comments

  • 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" 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 avatar Dec 29 '22 18:12 mkgrgis

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

mkgrgis avatar Jan 02 '23 10:01 mkgrgis