Re: [Ledger-smb-users] Upgrading lsmb-1.2 database

2014-10-13 Thread Chris Travers
On Mon, Oct 13, 2014 at 4:57 AM, Kai Huuhko wrote: > > > > > select a.accno, a.description, ac.amount, ac.transdate, ac.source, > ac.memo > > from account a > > join acc_trans ac on a.id = ac.chart_id > > where ac.trans_id not in ( > > select id from ar union select id from ap union select id fr

Re: [Ledger-smb-users] Upgrading lsmb-1.2 database

2014-10-13 Thread Kai Huuhko
2014-10-13 13:56 GMT+03:00 Chris Travers : > > > On Mon, Oct 13, 2014 at 3:45 AM, Kai Huuhko wrote: >> >> 2014-10-13 12:01 GMT+03:00 Chris Travers : >> > >> > >> > On Mon, Oct 13, 2014 at 1:20 AM, Kai Huuhko >> > wrote: >> >> >> >> Hi >> >> >> >> I'm attempting to upgrade an old database backup t

Re: [Ledger-smb-users] Upgrading lsmb-1.2 database

2014-10-13 Thread Chris Travers
On Mon, Oct 13, 2014 at 3:45 AM, Kai Huuhko wrote: > 2014-10-13 12:01 GMT+03:00 Chris Travers : > > > > > > On Mon, Oct 13, 2014 at 1:20 AM, Kai Huuhko > wrote: > >> > >> Hi > >> > >> I'm attempting to upgrade an old database backup that was created back > >> in 2011 using ledgersmb-1.2. > >> >

Re: [Ledger-smb-users] Upgrading lsmb-1.2 database

2014-10-13 Thread Kai Huuhko
2014-10-13 12:01 GMT+03:00 Chris Travers : > > > On Mon, Oct 13, 2014 at 1:20 AM, Kai Huuhko wrote: >> >> Hi >> >> I'm attempting to upgrade an old database backup that was created back >> in 2011 using ledgersmb-1.2. >> >> The pg_restore process completed successfully with just one trivial >> err

Re: [Ledger-smb-users] Upgrading lsmb-1.2 database

2014-10-13 Thread Chris Travers
On Mon, Oct 13, 2014 at 1:20 AM, Kai Huuhko wrote: > Hi > > I'm attempting to upgrade an old database backup that was created back > in 2011 using ledgersmb-1.2. > > The pg_restore process completed successfully with just one trivial > error: could not execute query: ERROR: language "plpgsql" al

[Ledger-smb-users] Upgrading lsmb-1.2 database

2014-10-13 Thread Kai Huuhko
Hi I'm attempting to upgrade an old database backup that was created back in 2011 using ledgersmb-1.2. The pg_restore process completed successfully with just one trivial error: could not execute query: ERROR: language "plpgsql" already exists Trying to run the upgrade process using lsmb-1.4.4