search for: compositekeys

I´m looking for a way to work with compose primary keys. I alredy know that plugin http://compositekeys.rubyforge.org/ but it doesn´t have examples. Please help =] -- Horus Augustus C. C. Lima Sagarana Tech Mobile +55(85)8842.4402 Desk +55(85)3304.6530 augustus-b3GZhX+fmr6XmMXjJBpWqg@public.gmane.org http://www.sagaranatech.com --~--~---------~--~----~------------~-------~--~----~ You received t...

can you use 2 pirmary keys. the standard user_id key exists but i would also like to use another key for my links. i am not sure how to implement this. also i don''t want any auto incrementing of this second primary key that i would like to use for my relationships. if there is a good db, model, relationship tutorial out there i would love to know about it.

I''ve been trying to use Rails on a database where the biggest datawarehouse-style table doesn''t have a primary key. It really doesn''t make sense and just adds extra unnecessary space. I do have, however, a column that I normally use to search on (IP) that returns many rows. The table also references several other tables through rails-friendly foreign keys. Simple AR

i have two table, comment and post, both have composite keys, and no id column, comment belongs to post, i follow the instruction of http://compositekeys.rubyforge.org/, and it seems successfully, (But i still cant confirm to put require ''rubygems'' and require ''composite_primary_keys'' on which file ). I can do the CRUD operation for post,then i want to create comment form, in the _form.html.erb, the code likes bel...

Hi all, I have two tables: TABLE 1 A pk - fk (referencesc TABLE 2) B pk C pk D pk E F TABLE 2 A pk G H I L I don''t use incremental field (id). I''d like don''t use find_by_sql. How can I define both models to use correctly find method (with include)? With only one column primary key I haven''t problems. I thought two solutions, but I don''t like these

...y, the Composite Primary Key code promptly broke for anyone who updated their apps to Rails 1.1.6 (with its activerecord-1.14.4) Now the gem dependencies are fixed and your legacy databases are free to wield composite primary keys without fear again. Description: Composite Primary Keys (http://compositekeys.rubyforge.org/) is an extension to ActiveRecords to provide support for composite primary keys (Duh!) in a simple, transparent way. Your single primary key code should work with a composite primary key model. Associations can even include composite foreign keys. Dr Nic''s Blog: http://...

ActiveRecords with composite primary keys now seem to happily support find/create/update/destroy options. Url: http://compositekeys.rubyforge.org Background: Rails/ActiveRecords has long been critised for not supporting legacy databases, especially composite primary keys. This gem extends ARs with this support. Cheers Nic -- Posted via http://www.ruby-forum.com/.

...3.3 Notes: Fixed errors with id= and create. Note, the create method does not use sequences to generate ids for you. If anyone has any use cases where their DBs generate ids for their composite keys, pls let me know - we may need to add some syntax to the set_primary_keys command. Url: http://compositekeys.rubyforge.org Summary: ActiveRecords/Rails famously doesn''t support composite primary keys. For 2 years there has been no support for this aspect of legacy databases. This project will be a fully-featured solution and I welcome use cases and legacy DB schema samples to help make the pr...

Is it true that Rails needs a single column to uniquely identify a row in table? If yes, doesn''t this limit the database design and disables the use of Rails for legacy databases? /Fredrik -- Posted via http://www.ruby-forum.com/.

Have been looking into using rails but am finding the "Composite Primary Keys are Bad" thing a tad disturbing (to put it mildly). I have been working with RDBMS systems for over fifteen years and this is the first time I have herd the idea questioned. I have cone across using surrogate keys which mirror the composite key for performance reasons in VERY big databases but I have never

I have a small table that is used to temporarily queue requests, as such it does not have an id field (or any other primary key), because it doesn''t make sense to have one. When I created an ActiveRecord class and tried to save it, I get: ActiveRecord::StatementInvalid: PGError: ERROR: relation "temp_requests_id_seq" does not exist It keeps looking for the id to auto

Frankly I''m losing tolerance for the MS "stack." And I''m intrigued by Rails. But in my outfit I''m not only the web person, but also the application person and the DBA. So when I read that Rails doesn''t want to handle things like "compound keys" I blew right by those claims, thinking, "no way." But before I go deeper, I

I am mapping ActiveRecord classes to an existing Oracle database. This means I cannot change the database schema to fit ActiveRecord conventions. Predictably, I have gotten into trouble: I have several join tables that do not have a primary key column, and therefore no number sequence defined. ActiveRecord insists on requiring a sequence, and gets unhappy when there is none to find. Is there a