[Rails-core] acts_as_taggable and postgresql

[Blair Zajac]

Paulo Geyer wrote:
> 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 <http://tags.id>
>                 AND ( tags.name <http://tags.name> = 'voip')
>                 AND posts.id <http://posts.id> = tags_posts.post_id 
> GROUP BY posts.id <http://posts.id> HAVING COUNT( posts.id 
> <http://posts.id>) = 1

This has been reported on the acts_as_taggable project and contains a suggested fix:

http://rubyforge.org/tracker/index.php?func=detail&aid=2482&group_id=923&atid=3629

It would be nice if a new release was put out.

Regards,
Blair

-- 
Blair Zajac, Ph.D.
CTO, OrcaWare Technologies
<blair at orcaware.com>
Subversion training, consulting and support
http://www.orcaware.com/svn/