|Subject:||Ordered component _shift_siblings fails with Postgresql|
The single query used in _shift_siblings can fail in Postgresql because UNIQUE constraints are checked during the single query and the order of moving is not guaranteed. If the UNIQUE( position, group ) is deferred then it will work, but we are running 8.4.5 which doesn't support that. See:The old approach (where each row was moved in a separate query) works, of course, but it's less ideal than a single query. Perhaps the approach can be configurable? I'm simply overriding the Ordered component so it's not difficult to revert to the old code in my case. See also list discussion: DBIx::Class::Ordered changes. on Sept 18, 2012.