[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