'Cannot create Table in graph schema , Agensgraph
I am trying to import Northwind dateset as mentioned in this tutorial 'https://bitnine.net/tutorial/tutorial_eng.html?ckattempt=1', I did the same process but when i create new foreign table 'categories' or for other table it give the same error: "cannot create table in graph schema".
DROP GRAPH northwind CASCADE;
CREATE GRAPH northwind;
SET graph_path = northwind;
DROP SERVER northwind;
CREATE SERVER northwind FOREIGN DATA WRAPPER file_fdw;
CREATE FOREIGN TABLE categories (CategoryID int,
CategoryName varchar(15),
Description text,
Picture bytea
)
SERVER northwind
OPTIONS (FORMAT 'csv', HEADER 'true', FILENAME 'D:\northwind \categories.csv', delimiter ',', quote '"', null '');
Error:"cannot create table in graph schema"
There is any solution for it please let me know.
agensgraph : (AgensGraph 2.1.2, based on PostgreSQL 10.4) OS: Windows 10 X64
Same question: migrating to agensgraph create foreign table error
Thanks in advance!!!
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
