From: Glen Holcomb <damnbigman@...>
Date: 2008-06-25T03:13:50+09:00
Subject: Re: Sequel primary keys

------=_Part_29082_30317308.1214331350324
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

On Tue, Jun 24, 2008 at 11:03 AM, Robert Klemme <shortcutter@googlemail.com>
wrote:

> On 24.06.2008 18:01, Glen Holcomb wrote:
>
>> I posted to the Sequel Google Group but it's horribly slow, assuming it
>> took
>> my post.
>>
>> Does anyone on here know if it is possible to create a non-integer primary
>> key in Sequel?  If so how?  Also help with creating a non integer foreign
>> key would be great too.  I've done some poking through the Rdoc and some
>> experimentation and it wants to make everything :integer or AUTOINCREMENT.
>>
>
> The docs seem to indicate that you can use arbitrary PK's:
>
> http://sequel.rubyforge.org/classes/Sequel/Schema/Generator.html#M000257
>
> So, if int is enforced there is a bug - either in your code or in Sequel's
> code.
>
> Kind regards
>
>        robert
>
>
Thanks for the input Robert.

It turns out there is a rather vaguely documented :auto_increment => false
that needed to be included in my primary_key definition.  Now I just need to
figure out how to get foreign_keys to work.  The sequel-talk group seems to
be working so I will continue this pursuit there.

Thanks again.

-- 
"Hey brother Christian with your high and mighty errand, Your actions speak
so loud, I can't hear a word you're saying."

-Greg Graffin (Bad Religion)

------=_Part_29082_30317308.1214331350324--