import csv to Agensgraph got this error!!

[AnwarsaeedDMU]

I apply the same process as mentioned in https://bitnine.net/tutorial/tutorial_eng.html?ckattempt=2 but I got this error. Any solution for it???

DataAccessException->StatementCallback; uncategorized SQLException for SQL [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 '');]; SQL state [XX000]; error code [0]; ERROR: cannot create table in graph schema; nested exception is org.postgresql.util.PSQLException: ERROR: cannot create table in graph schema, SQL Code->XX000

[kysmou]

Can you tell me the AgensGraph version information?

agens -Version

If you also tell us the search_path information, we will check it. sampledb=# show search_path;

[AnwarsaeedDMU]

AgensGraph 2.1.2 and agensbrowser 1.1, and "$user", public. so I know why this error occurs, it is because there are already nodes created on that search path so I remove it and make a new one, and then its works.

On Thu, Jun 16, 2022 at 1:29 PM YoungWoo kim @.***> wrote:

Can you tell me the AgensGraph version information?

agens -Version

If you also tell us the search_path information, we will check it. sampledb=# show search_path;

— Reply to this email directly, view it on GitHub https://github.com/bitnine-oss/agensgraph/issues/556#issuecomment-1157383291, or unsubscribe https://github.com/notifications/unsubscribe-auth/ASHXGNONSDIFCCKBS7JDEW3VPLQXXANCNFSM5SVGIWLA . You are receiving this because you authored the thread.Message ID: @.***>

[AnwarsaeedDMU]

@kysmou can you guide me how to use agensgraph graph with postgresql as extension. i installed agengraph 2.12 and also triewd 2.13 with postgresql 10, 13 and 14 but its not worked. can i have to install agensgraph in postgresql directory? please gide me on it for windows