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