torque 3.0b4: sequences in postgresql

[Bill Schneider]

I noticed that SQL is generated differently in Torque 3.0b4 for PostgreSQL
depending on whether "autoincrement='true'" is specified.

When you have

<table name="foo" idMethod="native">
  <column name="foo_id" primaryKey="true"/>
</table>

the resulting SQL works fine:
---
drop sequence foo_id_seq;
drop table foo;

create sequence foo_id_seq;
create table foo (
  foo_id ... default nextval('foo_id_seq');
);
---
If you add autoIncrement="true" to the column, instead you get
---
drop sequence foo_id_seq;
drop table foo;

create sequence foo_id_seq;
create table foo (
  foo_id ... serial;
);

the "serial" keyword implicitly creates a column that uses the sequence
"foo_foo_id_seq", which will not get dropped by the Torque-generated drop
script.

Why the difference in behavior?  Has it ever been decided whether the
autoIncrement property is semantically significant or a no-op?

-- Bill



--
To unsubscribe, e-mail:   <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>