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
<[EMAIL PROTECTED]>
Subversion training, consulting and support
http://www.orcaware.com/svn/
_______________________________________________
Rails-core mailing list
[email protected]
http://lists.rubyonrails.org/mailman/listinfo/rails-core
