[Rails-core] acts_as_taggable and postgresql

[Paulo Geyer]

thanks!
this patch has worked for me

On 2/2/06, Blair Zajac <blair at orcaware.com> 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
> <blair at orcaware.com>
> Subversion training, consulting and support
> http://www.orcaware.com/svn/
> _______________________________________________
> Rails-core mailing list
> Rails-core at lists.rubyonrails.org
> http://lists.rubyonrails.org/mailman/listinfo/rails-core
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://wrath.rubyonrails.org/pipermail/rails-core/attachments/20060202/c01e060a/attachment.html