[Pkg-sql-ledger-discussion] Bug#675816: instructions for rollback

[Robert James Clay]

On Thu, 2012-06-07 at 17:36 -0400, Moshe Yudkowsky wrote:
> I'd like to experiment with repairs, but I can't find instructions on 
> how to roll back after a failed update.
> 
> I can see that the old 1.2 tables are in the db, but I don't know how to 
> drop the 1.3 tables and re-try the update. I'm certain it's possible...

  As one of the LedgerSMB authors wrote recently, after the
LedgerSMB/TXT.pm issue but before the possible name constraint issue
came up:

On Tue, 2012-06-05 at 02:52 -0400, Chris Travers wrote in the 
ledger-smb-users mailing list:
> Just in case you ever need this, there is a 1.3-1.2.sql file in the
> sql/upgrade directory.  The upgrade is actually a move-and-import
> operation so this will restore you to 1.2.  Note that this does *not*
> remove the old 1.3 schema. Since we know what the problem was and no
> further troubleshooting is required, you probably want to
> 
> drop schema lsmb13_fail cascade;
> 
> After you run the downgrade script.
>