Use Postgresql's reset_pk_sequence in Trac importer to reset issue id sequence (#595).

git-svn-id: http://redmine.rubyforge.org/svn/trunk@1119 e93f8b46-1217-0410-a6f0-8f06a7374b81

1 files changed, 2 insertions, 10 deletions

diff --git a/lib/tasks/migrate_from_trac.rake b/lib/tasks/migrate_from_trac.rake
index 63a719b35..2eca13dc3 100644
--- a/lib/tasks/migrate_from_trac.rake
+++ b/lib/tasks/migrate_from_trac.rake
@@ -373,16 +373,8 @@ namespace :redmine do
         	end
         end
         
-        # update issue id sequence if needed
-        begin
-          case ActiveRecord::Base.connection.adapter_name.downcase
-          when 'mysql'
-            # nothing to do
-          when 'postgresql'
-            sql = "SELECT setval('#{Issue.table_name}_id_seq', (SELECT MAX(id) FROM #{Issue.table_name}))"
-            ActiveRecord::Base.connection.execute(sql)
-          end
-        end
+        # update issue id sequence if needed (postgresql)
+        Issue.connection.reset_pk_sequence!(Issue.table_name) if Issue.connection.respond_to?('reset_pk_sequence!')
         puts
         
         # Wiki