[Rails-core] acts_as_taggable and postgresql

Paulo Geyer paulogeyer at gmail.com
Thu Feb 2 03:45:54 GMT 2006


anyone already has used acts_as_taggable with postgres?
i've tried here, and got this error when trying to use find_tagged_with:

>> Post.find_tagged_with :all => 'voip'
ActiveRecord::StatementInvalid: PGError: ERROR:  column "posts.title" must
appear in the GROUP BY clause or be used in an aggregate function
: SELECT posts.* FROM tags_posts, posts, tags WHERE tags_posts.tag_id =
tags.id
                AND (tags.name = 'voip')
                AND posts.id = tags_posts.post_id GROUP BY posts.id HAVING
COUNT(posts.id) = 1
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://wrath.rubyonrails.org/pipermail/rails-core/attachments/20060202/8431e06f/attachment.html


More information about the Rails-core mailing list