Hi All, I am porting from Postgres to HSQL and would like some of the tables in HSQL to be CACHED tables i.e. CREATE CACHED TABLE instead of the generic CREATE TABLE. I don't see a way to do this in the ant tasks. Is it doable in the APIs?
Ideally the task would allow you to specify the databasetype of the source and databasetype of the produced sql files separately, thereby allowing you to produce a platform-specific schema. Meanwhile, I am dumping the hsql schema using databaseToDdl as an sql file, doing some sed to make CREATE CACHED TABLE ddl and rebuilding the database using the ant sql task. Thanks, Niels ------------------------ Niels Voorhoeve Consultant - www.spectraseis.com
