search for: constraint_type

...i.uniqueness, lowe r(c.column_name) as column_name FROM user_indexes i, user_ind_columns c WHERE i.table_name = ''REGION'' AND c.index_name = i.index_name AND i.index_name NOT IN (SELECT index_name FROM user_constraints WHERE constraint_type = ''P'') ORDER BY i.index_name, c.column_position ____________________________________________________ I have the same error message in the db/schema.rb file for all the database tables (OCIError: ORA-00918: column ambiguously defined). could you help me please ? tha...

i''m a rails nuby so i don''t know where to fix this in the activerecord module.... there is no such column in the sys.view.user_constraints. SELECT uc.index_name FROM user_constraints uc WHERE uc.constraint_type = ''P'' this prevents me from doing a rake test:functionals ...as in below.... C:\railsspace>c:\ruby186\ruby\bin\ruby c:\ruby186\ruby\bin\rake test:functionals --trace (in C:/railsspace) ** Invoke test:functionals (first_time) ** Invoke db:test:prepare (first_time) ** Invoke en...

Hi all, I''m using Rails/Mysql as development platform. the production server is under Rails/Oracle. Right now, i''m trying to install my application under the production server, the connection to orcale is fine via Rails, but i have a weird problem. example : here is a extract from my db scheme : Table User :_____________ id_user | first_name |

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