Dods: bug in dods 5.1
"Kip C. Lubliner" <[email protected]> Fri, 7 Nov 2003 18:22:18 -0500 (EST)
| Newsgroups | gmane.comp.java.enhydra.dods |
|---|---|
| Message-ID | <[email protected]> |
Hello, I am a new user to DODS, and Enhydra. I build a small doml file, and generated the SQL for Postgres. the SQLcreate.sql file didn't work. Upon further inspection, the problem is that dods re-ordered my list of tables. In my original DODS file, all tables only referred to tables earlier in the file - but after the re-ordering, this is no longer the case. This isn't that big of a deal - I simply re-ordered the order of table creation, and then it worked. However, it is possible to have two tables that refer to each other. In such a case, no re-ordering will fix the problem. In this case, the only solution is to put the referential integrity constraints in after the create table statements. Thanks, Kip