On Fri, Nov 07, 2008 at 03:04:03PM -0500, Brian Long wrote:
> Since the sqlmeta createSQL code gets run after table creation,
> specifying "ALTER TABLE foo ENGINE InnoDB" runs after the foreign key
> constraint was created.  This means I have to re-construct / re-add
> the constraint inside createSQL.  Are there any better ways to
> accomplish this?

   There is no, currently. IWBN for SQLObject to grow a concept of table
parameters. PostgreSQL, e.g., has a number of table parameters, like this:

CREATE TABLE cinemas (
   id serial,
   name text,
) INHERITS (parent_table) TABLESPACE diskvol1;

> Are there any plans to change this in an upcoming release?

   No, nobody has sent a patch. Do you want to be the champion?

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            [EMAIL PROTECTED]
           Programmers don't die, they just GOSUB without RETURN.

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
sqlobject-discuss mailing list
sqlobject-discuss@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to