Hi All,
I'm trying this promising software, but I get a serious problem while trying to create a publication.
I try to synchronize the database for a quite big application, TinyERP. The organization of postgresql tables for this application is quite complex ...
So when I try to create a publication, I start by putting one table. I get the message shown in attachment : "List passed doesnt contain superTable {0} for table {1}".
Well, the message is not perfectly usable, as you can guess : I can't know which table causes the problem. So, for my test, I have included all "dependencies" in the list of tables ; I mean, every tables which are linked by a foreign key to my main table and to linked tables. Nothing seem to work, because I still obtain this unusable message.
Is it a (already known ?) bug, or does it come from my configuration ?
Thanks
Patrice
| Attachment | Size |
|---|---|
| Capture-Error Message.png | 8.71 KB |
This happens because the
This happens because the table you are trying to publish has foreign key references to tables not included in your publication. I'll try to make that error print out more information in the 2.2.4 release, but that's the problem. You have to make sure to include all tables which are referenced by foreign keys in the tables you're publishing.
I hope that's clear enough.
Brian
Of course, I thought about
Of course, I thought about this. This is a very annoying problem.
So I tried another test : put every tables in one shot. Like this, no table should miss.
So, it appear another problem : circular paths.
I have tried DBReplicator because I thought that it was much more simple to use than SymmetricDS. This is finally not the case. I think that DBReplicator is not so serious to be used.
Sorry
Bye