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
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
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.
> >>
>
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
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
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