On Sat, Feb 25, 2006 at 10:12:38AM -0700, Michael Fuhr wrote: > > If it is not correct, how can I rotate the records in the table? > > One way would be to use a trigger to delete records having the same > event_id as the record being inserted.
I should mention that with the example I posted you can still get duplicate key violations if enough concurrent transactions insert into the table at the same time. I'll have to think a little more about the best way to avoid that. -- Michael Fuhr ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
