Hi,

I just found that with 2 unique constraints in a relation,
torque-3-b4-dev generates indeces with the same name for postgresql. I
have temporarily worked round this by adding the unique column name to
the index name as follows. This works for my application ( two single
column constraints) but I don't think this is a good solution. I have
not yet found my way through the code to work out what was intended.

base/postgresql/unique.vm

#foreach ($unique in $table.Unices)
    CONSTRAINT ${unique.Name}${unique.ColumnList} UNIQUE
($unique.ColumnList),
#end

Regards,

Peter




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

Reply via email to