Ok, so this is going to sound a bit foolish, since I contributed both
the DbGeneratorTask and the patch to let PostgreSQL use sequences, but
in my defense, I think Andrus modified the former ;-)
Anyway, it appears that the SQL that the task is generating is vastly
different from that generated by the modeler. In particular, the former
is using AUTO_PK_SUPPORT while the latter creates the sequences
appropriately. Before I crack open the source to see why this is, has
anyone observed this behavior with other RDBMS that Cayenne uses
sequences for? I.e., I'd like to know if this is specific to PostgreSQL
or affects all DB adapters that use sequences.
Thanks,
Kevin
This archive was generated by hypermail 2.0.0 : Thu Jul 07 2005 - 21:52:54 EDT