activerecord-postgres-hstore
activerecord-postgres-hstore copied to clipboard
diogob
Goodbye serialize, hello hstore. Speed up hashes in the database.
Defining the index type, on options, is falling back to gist add_hstore_index :people, :info, :type => :gin the above example is not creating a type gin index.
When I update other fields, the hstore column, is always set as well. ``` ruby post = Post.create(title: 'Title') post.update_attribute(:title, 'Title2') # (0.2ms) BEGIN # (0.4ms) UPDATE "posts" SET "title"...
I am using rails 5 and ruby 2.3.1. when i installed activerecord-postgres-hstore gem i got following error. /activesupport-5.0.0.1/lib/active_support/core_ext/module/aliasing.rb:37:in `alias_method': undefined method`simplified_type' for class `ActiveRecord::ConnectionAdapters::PostgreSQLColumn' (NameError) from /activesupport-5.0.0.1/lib/active_support/core_ext/module/aliasing.rb:37:in`alias_method_chain'.
~/.rvm/gems/ruby-2.3.1@global/gems/activesupport-4.2.6/lib/active_support/core_ext/module/aliasing.rb:32:in `alias_method': undefined method`simplified_type' for class `ActiveRecord::ConnectionAdapters::PostgreSQLColumn' (NameError)
Given your example `Person.where("data ? 'foo'")`, how would one rewrite that to use a bound variable? `Person.where("data \? ?")` results in `ActiveRecord::PreparedStatementInvalid: wrong number of bind variables (1 for 2)`.
This is Rails 3.2. I'm getting the following error, but only when the method is executed via Sidekiq: ``` 2014-08-14T15:14:25.255Z 23335 TID-ovtw9n32c WARN: undefined method `scan' for {}:Hash 2014-08-14T15:14:25.255Z 23335...
`MyModel.update_all(:properties => {'a' => 1})` tries to issue an UPDATE statement with properties set to the serialized YAML hash (and fails). Is this a bug or intended behaviour? Similarly the...
I have a Rails 3.2.11 app to which I tried adding Postgres Hstore using the activerecord-postgres-hstore gem. The app works find in development with PG-9.1.9 db, but gives the following...
I fetch record with hstore column and do `row.save` It is always issue UPDATE sql, is it the default behavior? Any way to fix it?
When rolling back the database the code from the readme doesn't work for me: ``` ruby def change add_hstore_index :people, :data end ``` I had to separate it into the...
