1

I’m getting issue when creating the foreign table. I think griddb_fdw can not link table "T 1" to foreign table "ft1".

CREATE FOREIGN TABLE ft1 (
    c0 int,
    "C 1" int NOT NULL,
    c2 int NOT NULL,
    c3 text,
    c4 timestamptz,
    c5 timestamp,
    c6 varchar(10),
    c7 char(10) default 'ft1',
    c8 text
) SERVER griddb_srv;
ALTER FOREIGN TABLE ft1 DROP COLUMN c0;
ALTER FOREIGN TABLE ft1 OPTIONS (table_name 'T 1');
\det+
                    List of foreign tables
 Schema | Table |  Server  |    FDW options     | Description 
--------+-------+----------+--------------------+-------------
 public | ft1   | loopback | (table_name 'T 1') | 
(1 row)

SELECT * FROM ft1;
ERROR:  No such container: ft1
server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.
connection to server was lost

Could you please fix this issue?

0 Answers0