search for: data_default

...do |t| t.column "username", :string t.column "created_on", :datetime t.column "email", :string t.column "note", :text end And everything works fine, but in development, it has to run this query for each view select column_name, data_type, data_default, nullable, decode(data_type, ''NUMBER'', data_precision, ''VARCHAR2'', data_length, null) as length, decode(data_type, ''NUMBER'', data_scale, null) as scale from user_catalog cat, user_synonyms syn, all_tab_columns col where cat.table_name = ...

.... If anybody else has this problem or if anybody wants to include the change into the next ActiveRecord version, here is what I''ve changed: in activerecord-1.13.2/lib/active_record/connection_adapters/oci_adapter.rb at line 341 (in the #columns method): - select column_name, data_type, data_default, nullable, + select /*+ RULE */ column_name, data_type, data_default, nullable, Best regards and thanks for the great framework, Andreas Gungl

...tabase, approx. 1700 tables and 4 million rows, I discovered an inefficiency in oci_adapter.rb. The problem seems to be the SQL being generated to lazy-load the columns metadata. "def columns(table_name, name = nil)" method generates the following SQL: select column_name, data_type, data_default, nullable, decode(data_type, ''NUMBER'', data_precision, ''VARCHAR2'', data_length, null) as length, decode(data_type, ''NUMBER'', data_scale, null) as scale from user_catalog cat, user_synonyms syn, all_tab_columns col where cat.table_name = ...

Greetings, I''m trying to put a Rails face on a Legacy Oracle 10 table. I am currently setting the table_name and primary_key, and I get the list and show to work fine. However, when I hit edit I just get the Editing <table name>, Edit button, Show, and Back. None of the fields are rendered. Why would I be able to show these fields in the show and list, but not edit them in the