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.

Yup, can do :slight_smile:

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

Andrew Timberlake - The SIMPLE way to manage your savings