On Tue, May 18, 2010 at 9:29 AM, Rich Shepard <[email protected]> wrote: > On Sat, 15 May 2010, Rich Shepard wrote: > >> I looked at acc_trans and gl, but the select statements returned nothing. > > Ah, me! User error. I was working with the database with me as the user > rather than with postgres as the user. As soon as I switched to user > 'postgres' the commands worked as expected. > > Mea culpa! And thanks to Armaghan and Wallace.
Glad to help. That's why I posted the entire transcript; every little part is important, including the "su - postgres" command. -- Best Regards, Wallace _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
