Are you _sure_ you had the dummy fks set? If it is really set there will never be any foreign key exceptions. It may be that it is set and you are really getting another error back, like a transaction timeout or something.

-David


On Dec 8, 2006, at 11:43 AM, Walter Vaughan wrote:

After loading a good amount of data into ofBiz with mySQL as the back end, I decided to use postgreSQL.

From the webtools, the sensible thing would be to do is create a backup with
"XML_DATA_EXPORT_ALL" creating a folder in the temp directory.

Then switch the config to use "localpostgres" instead of "localmysql" with the required changes inside that xml.

I then created a new empty database and ran ant run-install-seed. So far so good.

I then ran the XML_DATA_IMPORT_DIR from webtools, and watched the logs.

Woops!! Almost nothing loads because of key restraints, even checking "DummyFK's".

Well, Now I am wondering how that could ever work the way it seems it should.

I thought I read that dumping and reloading was a feature of the the entity engine data tools, but googling got me nowhere.

Help!

--
Waltr

Reply via email to