Displaying 12 results from an estimated 12 matches for "remove_index".
Did you mean:
remote_index
2010 Mar 30
2
remove_index missed quote_table_name
in lib/active_record/connection_adapters/abstract/schema_statements.rb
there is a missing quote_table_name in line 286 (def remove_index):
execute "DROP INDEX #{quote_column_name(index_name(table_name,
options))} ON #{table_name}"
so my "keys" table can get an index with "add_index" but can''t remove
it (without tweaking)
replacing it to
execute "DROP INDEX #{quote_column_name(index_na...
2006 Nov 28
3
remove_index appends suffix "_index" to the given name!
Hi all
This creates an index with the name position_and_produkt_id_uniq:
add_index :bilder, [:produkt_id, :position], :unique => true, :name =>
:position_and_produkt_id_uniq
This should remove the same one:
remove_index :bilder, :position_and_produkt_id_uniq
Sadly I get the following error:
Mysql::Error: Can''t DROP ''bilder_position_and_produkt_id_uniq_index'';
check that column/key exists: DROP INDEX
`bilder_position_and_produkt_id_uniq_index` ON bilder
Why does Rails append the suffix...
2005 Nov 26
3
Several questions about Ferret.
...all I would like to say "thank you" to David for its really
valuable work. Ferret is a great project and it have great future.
Well now is my questions as beginner in Ferret.
How to remove ALL documents from index. Remove files is not a solution. I am
interesting in something like
index.remove_index or something like this. What is a usual way of doing it??
What is the name of default key field. (Field that we could later used in
method like as index.remove("23") ). In some docs I seen the name :id in
other as :key
What is the difference in soring field as string and as integer. For...
2007 Dec 21
0
db:migrate problem
...:remember_token
t.datetime :remember_token_expires_at
t.string :openid_url
end
add_index :people, :login
add_index :people, :email
add_index :people, :openid_url
end
...
end
004_drop_login_name:
class DropLoginName < ActiveRecord::Migration
def self.up
remove_index :people, :login
remove_column :people, :login
end
def self.down
raise ActiveRecord::IrreversibleMigration.new("can''t recover deleted
login names")
end
end
For some reason the cc app seems to be trying to run the migrations twice.
Any thoughts?
thanks in advance...
2008 Apr 08
1
Help with primary_key_prefix_type
...:limit => 120
t.string :entity_legal_form, :null => false,
:limit => 4
t.timestamps
end
add_index :entities, :entity_name,
:name => :idxU_entities_entity_name,
:unique => true
end
def self.down
remove_index :entities, :name => :idxU_entities_entity_name
drop_table :entities
end
end
When I run these rake tasks:
rake db:drop
rake migrate
Then I see this:
# sqlite3 db/development.sqlite3
SQLite version 3.3.6
Enter ".help" for instructions
sqlite> .schema entities
CREATE TABLE...
2006 Jun 15
6
Newbie''s problem with a nil object he didn''t expect!
Dear Rubyists/Rails gurus,
Though I''ve successfully completed the various Rails tutorials online
and the Depot application from the Agile Web Development with Rails
book, I''m still pretty much a Ruby/Rails newbie. I''m trying to learn by
writing my own simple blogging application, but I''ve run into a problem
that has had me scratching my head for a few days now.
2006 Apr 02
5
adding primary_key to join table using migrations
Hi list,
My tag_question_user join table is not currently a full-blown model. It
doesn''t have a primary key - just tag_id, question_id, and user_id.
I now want to add a primary key to this model (because I want to add a
"description" column as well so users can describe the tag.
I''m not sure how to add this using migrations.
Here is what I have:
class AddNotesToTags
2006 Sep 05
0
rake craziness with Migrate as a dependency
...s, :shipment_received_on, :date, {:null=>true})
-> 0.2000s
-- remove_column(:products, :shipment_received_at)
-> 0.1900s
== UpdateDateTimeToDate: migrated (0.3900s)
===================================
== FixSkusIndex: migrating
====================================================
-- remove_index(:skus, {:name=>"product_color"})
-> 0.2200s
-- add_index(:skus, [:product_id, :color_id, :size],
{:name=>"product_color_size", :unique=>true})
-> 0.2110s
== FixSkusIndex: migrated (0.4310s)
===========================================
== CreateImages: migrat...
2009 Sep 28
5
Multi-databases support
Hi,
While I was hacking ovirt-server, I have found that it's currently
restricted to Postgres DB. Even if I like postgres for serious work on a
server, I really prefer to hack/dev locally on a Sqlite or MySQL DB.
I have googled on rails in order to find a good answer for the "foreign
key problem" which forces OVirt to stay on pg. I have found a plugin on
this particular
2008 Apr 13
20
uninitialized constant
Hi guys, I''m part way through a RoR application, for some reason
whenever I add new controllers (using scaffold) I get an uninitialized
constant [name of controller] error.
The first few controllers work fine, the only thing I can see that I''ve
changed is the layout file (but scaffold creates a new layout for each
controller so can''t see that being the problem). You
2009 Jan 30
8
[PATCH 0/7] ocfs2: Directory indexing support
The following patches implement indexed directory support in Ocfs2, mostly
according to the design doc I wrote up a while ago:
http://oss.oracle.com/osswiki/OCFS2/DesignDocs/IndexedDirectories
The patches have been rebased on top of 2.6.29-rc2. It should be trivial to
put them into merge_window. Things are what I'd call complete now. I'd like
to get these into the merge_window branch
2009 Mar 17
33
[git patches] Ocfs2 updates for 2.6.30
Hi,
The following patches comprise the bulk of Ocfs2 updates for the
2.6.30 merge window. Aside from larger, more involved fixes, we're adding
the following features, which I will describe in the order their patches are
mailed.
Sunil's exported some more state to our debugfs files, and
consolidated some other aspects of our debugfs infrastructure. This will
further aid us in debugging