ID not primary key with not unique values

Rails
1

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

2

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.

3

On Tue, May 26, 2009 at 6:11 PM, pepe [email protected] wrote:

Database: Oracle 10g

Thanks.

Pepe

Yup, can do :slight_smile:
See: ActiveRecord::Base

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

Andrew T.
http://ramblingsonrails.com

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