Skip to content

Foreign server name quoting during IMPORT FOREIGN SCHEMA #31

Open
@mkgrgis

Description

@mkgrgis
  • 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 テスト

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions