On 29 Apr 2017 3:05 a.m., "Joe Guerra" <jgue...@jginfosys.com> wrote:
oh, right. Just to do some minor things, but with pgadmin you have to write a bunch of sql. What sort of minor things? Often you can do things from the rails console. On Friday, April 28, 2017 at 9:18:54 AM UTC-4, Colin Law wrote: > > On 28 April 2017 at 14:15, Joe Guerra <jgu...@jginfosys.com> wrote: > > Got it working. I was just using the default settings that ror. It's > much > > easier to deal with sqlite in development. I hate using PGAdmin for > > postgres. > > Why do you have to use pgadmin? You should very rarely have to go > direct to the database. > > Colin > > > > > Thanks, > > Joe > > > > On Thursday, April 27, 2017 at 7:30:10 PM UTC-4, jim wrote: > >> > >> > >> > >> On Fri, Apr 28, 2017 at 9:17 AM, Joe Guerra <jgu...@jginfosys.com> > wrote: > >>> > >>> ok, I'm having difficulty with heroku, they are having some build > >>> problems... > >>> > >>> I'll try later. I guess commenting out the # rename table in change > def > >>> should work? > >>> > >>> I was puzzled because the column title started with a capital letter, > it > >>> worked fine in sqlite, but generated errors in postgres. (so the > quickest > >>> fix for me was to edit the column in postgress directly). I belive I > >>> skipped this migration before, but I forget how I did that. > >> > >> > >> is there anything that keeps you from using postgres for development? > >> > >>> > >>> > >>> Thanks, > >>> Joe > >>> > >>> On Thursday, April 27, 2017 at 7:02:48 PM UTC-4, jim wrote: > >>>> > >>>> > >>>> > >>>> On Fri, Apr 28, 2017 at 8:54 AM, Joe Guerra <jgu...@jginfosys.com> > >>>> wrote: > >>>>> > >>>>> Hi, I got stuck on a migration (basically to fix a column name). I > >>>>> actually went into the table itself and corrected the problem. My > herkou > >>>>> migration gets stuck, and I've got other migrations behind it that > aren't > >>>>> running. > >>>> > >>>> > >>>> If you've already fixed the table manually, then you don't need to > run > >>>> the migration at all. You have 3 hackish options > >>>> > >>>> 1. Just delete the migration and update the old migration so it uses > >>>> the correct column name. > >>>> 2. Insert the timestamp of the migration that you want to skip to a > >>>> table called schema_migrations (not sure if this is > >>>> the exact name). Rails basically checks this table to see which > >>>> migrations need to run. > >>>> 3. Edit the migration so that it doesn't do anything, commit, > deploy, > >>>> run db:migrate. Edit the migration again, commit, > >>>> deploy, run db:migrate. The second db:migrate should not run the > edited > >>>> migration file. > >>>> > >>>> May I ask why you decided to fix the table manually? > >>>> > >>>>> > >>>>> What should I do? > >>>>> > >>>>> Thanks, > >>>>> Joe > >>>>> > >>>>> -- > >>>>> You received this message because you are subscribed to the Google > >>>>> Groups "Ruby on Rails: Talk" group. > >>>>> To unsubscribe from this group and stop receiving emails from it, > send > >>>>> an email to rubyonrails-ta...@googlegroups.com. > >>>>> To post to this group, send email to rubyonra...@googlegroups.com. > >>>>> To view this discussion on the web visit > >>>>> https://groups.google.com/d/msgid/rubyonrails-talk/9567374e- > 3003-4dde-8e3c-cf6c834247e4%40googlegroups.com. > >>>>> For more options, visit https://groups.google.com/d/optout. > >>>> > >>>> > >>>> > >>>> > >>>> -- > >>>> ------------------------------------------------------------- > >>>> visit my blog at http://jimlabs.herokuapp.com > >>> > >>> -- > >>> You received this message because you are subscribed to the Google > Groups > >>> "Ruby on Rails: Talk" group. > >>> To unsubscribe from this group and stop receiving emails from it, send > an > >>> email to rubyonrails-ta...@googlegroups.com. > >>> To post to this group, send email to rubyonra...@googlegroups.com. > >>> To view this discussion on the web visit > >>> https://groups.google.com/d/msgid/rubyonrails-talk/f4266b4f- > c569-4820-891f-2e7ba8a89126%40googlegroups.com. > >>> > >>> For more options, visit https://groups.google.com/d/optout. > >> > >> > >> > >> > >> -- > >> ------------------------------------------------------------- > >> visit my blog at http://jimlabs.herokuapp.com > > > > -- > > You received this message because you are subscribed to the Google > Groups > > "Ruby on Rails: Talk" group. > > To unsubscribe from this group and stop receiving emails from it, send > an > > email to rubyonrails-ta...@googlegroups.com. > > To post to this group, send email to rubyonra...@googlegroups.com. > > To view this discussion on the web visit > > https://groups.google.com/d/msgid/rubyonrails-talk/7476074e- > 9b38-4d0c-8c09-cc8320e689e3%40googlegroups.com. > > > > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscr...@googlegroups.com. To post to this group, send email to rubyonrails-talk@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/ msgid/rubyonrails-talk/0bcd9ba2-e6ca-47e0-bfc9-779d222ab336%40googlegroups. com <https://groups.google.com/d/msgid/rubyonrails-talk/0bcd9ba2-e6ca-47e0-bfc9-779d222ab336%40googlegroups.com?utm_medium=email&utm_source=footer> . For more options, visit https://groups.google.com/d/optout. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscr...@googlegroups.com. To post to this group, send email to rubyonrails-talk@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rubyonrails-talk/CAL%3D0gLvrEinZOh9U6eYcoh2VwMOEEz%3DdaiO3ksfmWnkr7ULdUw%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.