Import of Tables is very convenient.
However, SQL errors occur when we use foreign keys.
For example, we suppose that schema "public"
includes table booktitle and bookitem(which has a
foreign key "isbn" that refers primary key of
booktitle "isbn",), and we want to import those tables
into schema "test".
On executing Import operation, an error occurs because
of SQL statement as follows:
---SQL statement---
alter table "test"."bookitem" add constraint "fkey_isbn"
foreign key ("isbn") references "test"."public"."booktitle"
("isbn") on delete no action on update no action
---error message---
dbedit.core.DataException: Couldn't execute query:alter
table "test"."bookitem" add constraint "fkey_isbn"
foreign key ("isbn") references "test"."public"."booktitle"
("isbn") on delete no action on update no action
java.sql.SQLException: ERROR: cross-database
references are not implemented: "test.public.booktitle"
We have to delete `"public".` in order to finish Import
normally.
file for import table "bookitem"