On Fri, Apr 23, 2010 at 10:27 PM, steve jobs <[email protected]> wrote:
>> Let me know if there is still any issue. If you still get any error
>> messages, include them in your reply.
>
> Thanks. First problem that Backup is not working. When I make an backup
> am.pl has an error:
>
> DBD::Pg::db selectrow_array failed: ERROR: relation "entry_id" does not
> exist
> LINE 1: SELECT last_value FROM entry_id
> ^ at SL/AM.pm line 1638.
This is certainly due to missing entry_id sequence and related missing
column in acc_trans table. This was pointed out by other users in
response to your email. I shall copy the copy below again which need
to run in psql after you restore your backup.
CREATE SEQUENCE entry_id;
SELECT nextval ('entry_id');
ALTER TABLE acc_trans ADD COLUMN entry_id INTEGER DEFAULT nextval('entry_id');
I shall look at other issues and try to reproduce issue at my end.
Regards
Armaghan
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
