# Update\_all broken in postgres?

**URL:** <https://www.ruby-forum.com/t/update-all-broken-in-postgres/62189>\
**Category:** Rails\
**Created:** [June 1, 2006, 11:04am UTC](https://www.ruby-forum.com/t/update-all-broken-in-postgres/62189 "2006-06-01T11:04:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![iphan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/7993a0/32.png) [@iphan](https://www.ruby-forum.com/u/iphan)\
**Post date:** [June 1, 2006, 11:04am UTC](https://www.ruby-forum.com/t/update-all-broken-in-postgres/62189/1 "2006-06-01T11:04:44Z")

</div>

Hi

has anyone managed to use update\_all with rails on postgres?

In my setup, it does not work:

> > @keyword.update\_all(myupdates)  
> > NoMethodError: undefined method `update_all' for #<Keyword:0xb7ac4670> from /home/lib/ruby/gems/1.8/gems/activerecord-1.14.0/lib/active_record/base.rb:1786:in`method\_missing’  
> > from (irb):14

I checked that the base.rb class contains the update\_all method, so it  
seems like

```
    connection.update(sql, "#{name} Update")

```

isn’t working

---

<div class="post-metadata">

**Author:** ![iphan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/7993a0/32.png) [@iphan](https://www.ruby-forum.com/u/iphan)\
**Post date:** [June 1, 2006, 11:07am UTC](https://www.ruby-forum.com/t/update-all-broken-in-postgres/62189/2 "2006-06-01T11:07:34Z")

</div>

sorry just realised this is a class method, not an instance method!

---

<div class="post-metadata">

**Author:** ![iphan](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/i/7993a0/32.png) [@iphan](https://www.ruby-forum.com/u/iphan)\
**Post date:** [June 1, 2006, 11:11am UTC](https://www.ruby-forum.com/t/update-all-broken-in-postgres/62189/3 "2006-06-01T11:11:13Z")

</div>

update\_all is for ActiveRecord…use class\_name.update\_all