I don't think Heroku supports dropping the DB associated with your application, unless you delete the application itself - I am pretty sure that the Heroku guys do not create a separate user in their server for every user that signs up for the service - the management overhead would be insane.
I've always done rake db:reset; I once got myself into a situation where even rake db:reset didn't work, at which point I dropped myself to the console and manually removed all the tables, and then re-migrated, and everything was swell. Someone from heroku will probably be able to confirm better. On Mon, Jul 20, 2009 at 1:43 AM, jjh<jhirono2...@yahoo.com> wrote: > > Hi, > > I was trying to drop my database so I can re-rake it. But when I did > the following: > > heroku rake db:drop > > I got the following message: > > Couldn't drop qiutxbnatt : #<ActiveRecord::StatementInvalid: PGError: > ERROR: must be owner of database qiutxbnatt: DROP DATABASE IF EXISTS > "qiutxbnatt"> > > How can I set my own user privilege so I can drop the db and re-rake. > > Help please. > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Heroku" group. To post to this group, send email to heroku@googlegroups.com To unsubscribe from this group, send email to heroku+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/heroku?hl=en -~----------~----~----~----~------~----~------~--~---
