2 new commits in galaxy-central: https://bitbucket.org/galaxy/galaxy-central/commits/f9e3822c6407/ Changeset: f9e3822c6407 User: lance_parsons Date: 2012-12-10 22:23:11 Summary: Fix for Postgres versions < 9 (see https://trello.com/c/Z0EynAV2) Affected #: 1 file diff -r c3acc86490780d1949c4a3abf1263ace7c5ece6c -r f9e3822c64072c8466a39b5cbeaa4387e0c28ac8 scripts/set_user_disk_usage.py --- a/scripts/set_user_disk_usage.py +++ b/scripts/set_user_disk_usage.py @@ -52,7 +52,7 @@ sql = """ UPDATE galaxy_user SET disk_usage = (SELECT COALESCE(SUM(total_size), 0) - FROM ( SELECT d.total_size + FROM ( SELECT DISTINCT ON (d.id) d.total_size, d.id FROM history_dataset_association hda JOIN history h ON h.id = hda.history_id JOIN dataset d ON hda.dataset_id = d.id @@ -62,7 +62,7 @@ AND d.purged = false AND d.id NOT IN (SELECT dataset_id FROM library_dataset_dataset_association) - GROUP BY d.id) sizes) + ) sizes) WHERE id = :id RETURNING disk_usage; """ https://bitbucket.org/galaxy/galaxy-central/commits/5de636ce68fa/ Changeset: 5de636ce68fa User: dannon Date: 2013-06-06 16:21:57 Summary: Merged in lance_parsons/galaxy-central_postgres-user-disk-usage-fix (pull request #97) Fix for Postgres versions < 9 Affected #: 1 file diff -r af91c734dbb76b8c0e3166c7471370f9ba8260b5 -r 5de636ce68faededc52d7b0c16167fbef98be786 scripts/set_user_disk_usage.py --- a/scripts/set_user_disk_usage.py +++ b/scripts/set_user_disk_usage.py @@ -52,7 +52,7 @@ sql = """ UPDATE galaxy_user SET disk_usage = (SELECT COALESCE(SUM(total_size), 0) - FROM ( SELECT d.total_size + FROM ( SELECT DISTINCT ON (d.id) d.total_size, d.id FROM history_dataset_association hda JOIN history h ON h.id = hda.history_id JOIN dataset d ON hda.dataset_id = d.id @@ -62,7 +62,7 @@ AND d.purged = false AND d.id NOT IN (SELECT dataset_id FROM library_dataset_dataset_association) - GROUP BY d.id) sizes) + ) sizes) WHERE id = :id RETURNING disk_usage; """ Repository URL: https://bitbucket.org/galaxy/galaxy-central/ -- This is a commit notification from bitbucket.org. You are receiving this because you have the service enabled, addressing the recipient of this email.