# Postgres & Foxy Fixtures **URL:** \ **Category:** Rails\ **Created:** [December 24, 2007, 5:04pm UTC](https://www.ruby-forum.com/t/postgres-foxy-fixtures/124094 "2007-12-24T17:04:11Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![devaulw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/8e7dd6/32.png) [@devaulw](https://www.ruby-forum.com/u/devaulw)\ **Post date:** [December 24, 2007, 5:04pm UTC](https://www.ruby-forum.com/t/postgres-foxy-fixtures/124094/1 "2007-12-24T17:04:11Z")
I love foxy fixtures!!! However, when I rake my fixtures into my db the ID’s start out at 2million. Has any experienced this issue and have a work-around? Thanks, Bill ---
**Author:** ![devaulw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/8e7dd6/32.png) [@devaulw](https://www.ruby-forum.com/u/devaulw)\ **Post date:** [December 24, 2007, 5:16pm UTC](https://www.ruby-forum.com/t/postgres-foxy-fixtures/124094/2 "2007-12-24T17:16:08Z")
Why do you need a work-around? Two million is a perfectly valid integer. ---
**Author:** ![devaulw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/8e7dd6/32.png) [@devaulw](https://www.ruby-forum.com/u/devaulw)\ **Post date:** [December 26, 2007, 8:53am UTC](https://www.ruby-forum.com/t/postgres-foxy-fixtures/124094/3 "2007-12-26T08:53:32Z")
Hi Bill, On Dec 24, 2007 8:04 AM, Bill Davenport [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > However, when I rake my fixtures into my db the ID’s start out at > 2million. The fixture ID’s are generated using the fixture label, so they’re not sequential, and generally pretty large. This shouldn’t cause any problems. ~ j. ---
**Author:** ![devaulw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/8e7dd6/32.png) [@devaulw](https://www.ruby-forum.com/u/devaulw)\ **Post date:** [December 26, 2007, 4:19pm UTC](https://www.ruby-forum.com/t/postgres-foxy-fixtures/124094/4 "2007-12-26T16:19:37Z")
Thanks -bill ---
**Author:** ![devaulw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/8e7dd6/32.png) [@devaulw](https://www.ruby-forum.com/u/devaulw)\ **Post date:** [December 26, 2007, 4:34pm UTC](https://www.ruby-forum.com/t/postgres-foxy-fixtures/124094/5 "2007-12-26T16:34:11Z")
That does make sense John. Jumping from 2mil. to 1 trillion made me question what was going on. I’ve also been used to visually comparing id’s and single digits are much easier. Thanks again, bill ---
**Author:** ![devaulw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/8e7dd6/32.png) [@devaulw](https://www.ruby-forum.com/u/devaulw)\ **Post date:** [May 28, 2008, 1:52pm UTC](https://www.ruby-forum.com/t/postgres-foxy-fixtures/124094/6 "2008-05-28T13:52:44Z")
I’m getting problem with that. When rails create sequences in test database, it defines the start value with big numbers. I do know why rails does that. Bill Davenport wrote: > I love foxy fixtures!!! > > However, when I rake my fixtures into my db the ID’s start out at > 2million. > > Has any experienced this issue and have a work-around? > > Thanks, > Bill ---
**Author:** ![devaulw](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/8e7dd6/32.png) [@devaulw](https://www.ruby-forum.com/u/devaulw)\ **Post date:** [May 28, 2008, 7:02pm UTC](https://www.ruby-forum.com/t/postgres-foxy-fixtures/124094/7 "2008-05-28T19:02:42Z")
On Wed, May 28, 2008 at 7:52 AM, Davi Nascimento [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote: > > However, when I rake my fixtures into my db the ID’s start out at > > 2million. > > > > Has any experienced this issue and have a work-around? > > > > Thanks, > > Bill That’s the way foxy fixtures works, it uses a hash computed from the record name for the id. That’s how it can generate inter-table references. – Rick DeNatale My blog on Ruby [http://talklikeaduck.denhaven2.com/](http://talklikeaduck.denhaven2.com/)