[TORQUEOLD-344] Delete on a self referenced table

• Type: Bug
• Status: Open
• Resolution: Unresolved
• Old Scarab Id: TRQS327
• Assignee: Unassigned
• Reporter: Anonymous
• Created: 26/Sep/06 07:21
• Updated: 26/Sep/06 07:21

Description

I'm using Torque 3.2-rc2 with PostgreSQL 8.
When I try to delete a set of records which are referenced between them it fails because in the BasePeer class the final process to delete records do it one by one, and it casuses a foreign key violation.

Here is the BasePeer class code which I think may cause this problem, at line 374 ...

try
{
processTables(criteria, tables, con, new ProcessCallback() {
public void process(String table, String dbName, Record rec)
throws Exception

{ rec.markToBeDeleted(); rec.save(); }

});
}
catch (Exception e)

{ throwTorqueException(e); }