Thanks, Steve! When you do this, the standard drop.vm template will also drop the proper auto-generated sequence name before trying to re-create the table with the "serial" column.
-- Bill sbelt wrote: > There is a reply on this list archive. (I know because I asked ;) > > In your project-schema.xml, you can specify the sequence name. > For example, if the table name is MyTable and the autoseqenced > column is column1: > > <id-method-parameter value="myTable_column1_seq"/> > > This worked for me when it was placed after the column definitions > within the <table></table> tags. > > Steve B. > > ----- Original Message ----- > From: "Charles Duffy" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Wednesday, March 06, 2002 1:21 PM > Subject: torque (CVS) & postgresql 7.x sequence names > > > >>Howdy. >> >>I'm trying to use postgresql with torque (CVS 3/6/2002) and find that >>torque expects the sequences to be named as table_seq. This fails >>because in postgreSQL 7.x the autogenerated sequence names are >>table_column_seq. Is there any known workaround for this (other than >>using the idbroker)? I found another message describing the same problem >>on turbine-dev (<[EMAIL PROTECTED]>, from Aaron Brashears >>on Thu, 15 Mar 2001, archived at >>http://archive.covalent.net/jakarta/turbine-dev/2001/03/0176.xml), but >>no reply was visible. >> >>Thanks! >> >> > > > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
