i copy a table from postgres to oracle 10g, there is a error report in the end:
"copy failed : function information_schema._pg_keypositions() does not exist"
what does it mean? and in fact , all records have been copyed successful.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I just had this problem recently and found that I
was using the 8.0 driver with 8.1 postgres server.
Is this the case for you?
If you enable "Copy foreign keys" in the DBCopy
plugin configuration, then after the table data is
copied, the foreign key definitions are copied.
However, the 8.1 server no longer has the procedure _pg_keypositions that the 8.0 driver relies on.
Rob
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
i copy a table from postgres to oracle 10g, there is a error report in the end:
"copy failed : function information_schema._pg_keypositions() does not exist"
what does it mean? and in fact , all records have been copyed successful.
Hello,
I just had this problem recently and found that I
was using the 8.0 driver with 8.1 postgres server.
Is this the case for you?
If you enable "Copy foreign keys" in the DBCopy
plugin configuration, then after the table data is
copied, the foreign key definitions are copied.
However, the 8.1 server no longer has the procedure _pg_keypositions that the 8.0 driver relies on.
Rob