this patch has worked for me
On 2/2/06, Blair Zajac <[EMAIL PROTECTED]> wrote:
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
_______________________________________________ Rails-core mailing list [email protected] http://lists.rubyonrails.org/mailman/listinfo/rails-core
