The SQL that is produced for the primary key
is erroneous when the user has access to more than
one schema and the table and PK column exist in
more than one schema. Suppose that table 'test'
is in multiple schemas (A, B and C) that the user
has access to and with the same definition.
The SQL that is generated by DBCopy plugin
CREATE TABLE test (
PRIMARY KEY (pkcol, pkcol, pkcol)
This has to do with the code that queries the
metadata for PK for test doesn't specify the schema
or column. So PK columns for all accessible tables
named "test" in any schema are returned. The code
should be changed to respect schema (and if applicable,
Log in to post a comment.