I want a field in my table to be a sequence that is not the id of the record. Something like create_table :foo do |t| ... t.sequence :seq ... end Is there a clean way of doing this in migrations or will I end up having to hack something. Like having an integer field and copying in the id in an after_create filter? -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
What database are you using? I''m not aware of a "sequence" data type. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/qARmDs2QsEEJ. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
PostgreSQL has them, as do most DBs. This is where the ids come from. On 13 July 2011 15:10, Tim Shaffer <timshaffer-BUHhN+a2lJ4@public.gmane.org> wrote:> What database are you using? I''m not aware of a "sequence" data type. > > -- > You received this message because you are subscribed to the Google Groups > "Ruby on Rails: Talk" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/rubyonrails-talk/-/qARmDs2QsEEJ. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to > rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > For more options, visit this group at > http://groups.google.com/group/rubyonrails-talk?hl=en. >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Not quite. The id column is just an integer column. On MySQL, the id column is an integer column with auto_increment set. On PostgreSQL, it''s still an integer column, but rails also attaches a sequence object to it. Are you just looking to create another integer column that is auto incremented? -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/xm6ubJwDWqoJ. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
Yes, in PostgrSQL you would create an integer column and assign a sequence to it. I don''t know for sure but I expect that you cam do something similar with other databases. I was wondering if this had been abstracted away in ar On Wednesday, 13 July 2011, Tim Shaffer <timshaffer-BUHhN+a2lJ4@public.gmane.org> wrote:> Not quite. The id column is just an integer column. > > On MySQL, the id column is an integer column with auto_increment set. > > On PostgreSQL, it''s still an integer column, but rails also attaches a sequence object to it. > > Are you just looking to create another integer column that is auto incremented? > > > -- > You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. > To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/xm6ubJwDWqoJ. > To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en. >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.
It''s very definitely abstracted away in migrations. You write one basic migration, and the database adapter you''ve chosen takes care of these implementation details for you. I can use the same migration on my Mac with SQLite and on Heroku with PostgreSQL. No changes needed. Walter On Jul 13, 2011, at 2:03 PM, Peter Hickman wrote:> Yes, in PostgrSQL you would create an integer column and assign a > sequence to it. I don''t know for sure but I expect that you cam do > something similar with other databases. I was wondering if this had > been abstracted away in ar > > On Wednesday, 13 July 2011, Tim Shaffer <timshaffer-BUHhN+a2lJ4@public.gmane.org> wrote: >> Not quite. The id column is just an integer column. >> >> On MySQL, the id column is an integer column with auto_increment set. >> >> On PostgreSQL, it''s still an integer column, but rails also >> attaches a sequence object to it. >> >> Are you just looking to create another integer column that is auto >> incremented? >> >> >> -- >> You received this message because you are subscribed to the Google >> Groups "Ruby on Rails: Talk" group. >> To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/xm6ubJwDWqoJ >> . >> To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org >> . >> To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org >> . >> For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en >> . >> > > -- > You received this message because you are subscribed to the Google > Groups "Ruby on Rails: Talk" group. > To post to this group, send email to rubyonrails- > talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org > To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org > . > For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en > . >-- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en.