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




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

Hopefully AR would then then ignore the id field.


On Tue, May 26, 2009 at 6:11 PM, pepe removed_email_address@domain.invalid wrote:

Database: Oracle 10g



Yup, can do :slight_smile:

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

Andrew T. - The SIMPLE way to manage your savings