ID not primary key with not unique values

Sorry for the re-post. Nobody has even answered "no, can't do".

I have an ID column in a legacy table of type STRING and could contain not unique values. Is there a way of disabling the convention of ID being the primary key? How can I assign the values I need to the ID column without using SQL, which I already know would work?

ruby: 1.8.6 rails: 2.3.2 Database: Oracle 10g

Thanks.

Pepe

I believe the primary_key directive will tell AR what field to use as the actual PK. Something like:

  class MyClass < AR::Base     primary_key :actual_pk_field_name   end

Hopefully AR would then then ignore the id field.

Yup, can do :slight_smile: See: http://api.rubyonrails.org/classes/ActiveRecord/Base.html#M002232

Technically a primary key is not a primary key if it can contain duplicate (not unique) values

Andrew Timberlake http://ramblingsonrails.com

http://MyMvelope.com - The SIMPLE way to manage your savings