i added a column to the model and then deleted it. after that a :first call gave me a total arbitrary record. it changed from #9 to #75. all the data still remains in the table but a second migration to add the col with a loop to enter data gave me an out of range integer error. anyway to fix this? has anyone experienced this? i can still out put the table with a sort, but i am concerned of the integrity of the table. --~--~---------~--~----~------------~-------~--~----~ 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-/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 -~----------~----~----~----~------~----~------~--~---
some code would probably be handy - examples of what you''re trying. Julian. Learn Ruby on Rails! Check out the FREE VIDS (for a limited time) VIDEO #3 out NOW! http://sensei.zenunit.com/ On 10/04/2008, at 12:05 PM, rashantha wrote:> > i added a column to the model and then deleted it. after that a :first > call gave me a total arbitrary record. it changed from #9 to #75. all > the data still remains in the table > > but a second migration to add the col with a loop to enter data gave > me an out of range integer error. > > anyway to fix this? has anyone experienced this? > > i can still out put the table with a sort, but i am concerned of the > integrity of the table. > >--~--~---------~--~----~------------~-------~--~----~ 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-/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 -~----------~----~----~----~------~----~------~--~---
Most database engines don''t guarantee the order of a result set unless an ORDER BY clause is used. As I modify rows in PostgreSQL, the same query returns the rows in different order unless I specify and ORDER BY. Peace, Phillip -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ 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-/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 -~----------~----~----~----~------~----~------~--~---
Thanks, Phillip I too am using PostgreSQL the integer error was not related. On Apr 9, 7:12 pm, Phillip Koebbe <rails-mailing-l...-ARtvInVfO7ksV2N9l4h3zg@public.gmane.org> wrote:> Most database engines don''t guarantee the order of a result set unless > an ORDER BY clause is used. As I modify rows in PostgreSQL, the same > query returns the rows in different order unless I specify and ORDER BY. > > Peace, > Phillip > -- > Posted viahttp://www.ruby-forum.com/.--~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---