[MonetDB-users] Restore db on different platform / OID size
When attempting to restore a db dump, made on Windows 7 with 32 bits sized object ID's, on OSX with 64 bits sized object ID's, I run into errors. Like:
CREATE FUNCTION: name 'env' already in use
If I tweak the dump script by first dropping the functions that appear to exist, I get stuff like:
' from line 1 field 5 not inserted, expecting type real failed to import table
Should what I try to do be possible anyway? Am I doing anything wrong?
Thanks for your feedback.
Sander Kruseman
On 2011-04-15 10:17, Sander Kruseman wrote:
When attempting to restore a db dump, made on Windows 7 with 32 bits sized object ID's, on OSX with 64 bits sized object ID's, I run into errors. Like:
CREATE FUNCTION: name 'env' already in use
If I tweak the dump script by first dropping the functions that appear to exist, I get stuff like:
' from line 1 field 5 not inserted, expecting type real failed to import table
Should what I try to do be possible anyway? Am I doing anything wrong?
Thanks for your feedback.
Sander Kruseman
Those functions should not have been dumped (i.e., this is a bug in mclient). So, if you want to tweak you dump script, remove the create statements from the script instead of adding drop statements.
participants (2)
-
Sander Kruseman -
Sjoerd Mullender