Am 24.11.2011 19:30, schrieb Jeff Roberts:
Hi all
I did an upgrade earlier this year, upgraded to PGSQL 8.4 on FreeBSD and
SQL-Ledger 2.8.32.
Now when I look at the database with PGAdmin III it says that public.oe
doesn't have a primary key or OIDs and that I can view it but not edit it.
In principle, it's never a good idea to edit the tables directly.
I want to change the order number of a closed order so that a listing
comes out in the correct form, (the order number was entered
day/month/year/# instead of year/day/month/#)
Log in to psql, then enter
UPDATE oe SET ordnumber='<newnumber>' where id=<id>;
How is SQL-Ledger entering and editing this table without a primary key
or OIDs?
Like you see above.
What do I need to be able to edit my tables again?
You'd better forget about that. If you'd completely understand the data
model of SQL-Ledger, you wouldn't have to ask this question. Then you
would know for example that with the above command, you loose the
connection between the order and its related invoice. ;)
Regards
Tekki
_______________________________________________
SQL-Ledger mailing list
[email protected]
http://lists.ledger123.com/mailman/listinfo/sql-ledger
