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 _______________________________________________ Rails-core mailing list Rails-core@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails-core
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>) = 1This 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@orcaware.com> Subversion training, consulting and support http://www.orcaware.com/svn/
thanks! this patch has worked for me On 2/2/06, Blair Zajac <blair@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@orcaware.com> > Subversion training, consulting and support > http://www.orcaware.com/svn/ > _______________________________________________ > Rails-core mailing list > Rails-core@lists.rubyonrails.org > http://lists.rubyonrails.org/mailman/listinfo/rails-core >_______________________________________________ Rails-core mailing list Rails-core@lists.rubyonrails.org http://lists.rubyonrails.org/mailman/listinfo/rails-core