Hi All,
I have a strange schema name to work with in postgres "apac.logistics@vivn.com". The table name is "TableName"
I am trying to load data from an excel file by creating the above table using Postgres Bulk loader and it fails with the below error.
Error: Output Data (9): Error creating table "apac.logistics@vivn.com.TableName": ERROR: improper qualified name (too many dotted names): apac.logistics@vivn.com.TableName;
Error while executing the query
CREATE TABLE "apac"."logistics@vivn"."com"."TableName" ("Level 1" varchar(255),"Level 2" varchar(255),"Level 3" varchar(255))
Any help on getting this working even though the issue is with the bad schema naming I have no access to change the schema name and is in use by other project teams.
I have tried the following while specifying the conection string but none work
apac.logistics@vivn.com.TableName
"apac.logistics@vivn.com.TableName"
"apac.logistics@vivn.com"."TableName"
Please advise on how I can fix this and proceed with the data load on table creation
Thanks
Hello @JDong
I searched your error and found the below response:
On further researching, I was able to find that this was a known issue in Aurora Version 2.0 (compatible with 10.4) and the issue has been fixed on Aurora Version 2.1 ( compatible with PostgreSQL 10.5). I tried testing on my Aurora PostgreSQL 10.5 test cluster to confirm if the issue has been fixed and I was able to successfully execute the statement without any error message.
If possible, can you share a copy of your workflow as well? This will help to troubleshoot based on what tools you are using, and what tools are encountering this error message.
Thanks,
TrevorS