Changing to PG (Heroku deployment) and fix a PG bug with Post.writers

mrDoktar · May 14, 2010 · d0161b2 · d0161b2
1 parent 03a81dc
commit d0161b2
Show file tree

Hide file tree

Showing 2 changed files with 2 additions and 2 deletions.
diff --git a/Gemfile b/Gemfile
@@ -9,7 +9,7 @@ gem 'coderay'
 
 gem 'acts-as-taggable-on'
 
-gem 'mysql'
+gem 'pg'
 
 gem 'rubycas-client'
 

diff --git a/app/models/user.rb b/app/models/user.rb
@@ -2,5 +2,5 @@ class User < ActiveRecord::Base
   has_many :posts
 
   scope :admins, where(:admin => true)
-  scope :writers, joins("RIGHT JOIN posts ON posts.user_id = users.id").group(:user_id)
+  scope :writers, select("DISTINCT users.*").joins("RIGHT JOIN posts ON posts.user_id = users.id")
 end