On Fri, Nov 25, 2011 at 3:36 AM, Jeff Roberts <[email protected]> wrote: > I guess I'll ask a new question, phrased directly at the programmers. Can I > run an SQL script onto the tables to create primary keys or OIDs and still > have SQL-Ledger work afterwords or will creating a primary key on a table > break SQL's ability to access it?
Hi Jeff, 1. Take backup 2. Add ' WITH OIDS;' at the end of 'CREATE TABLE' of the tables you want to modify. 3. Restore backup. SQL-Ledger should have no issue with this change. This has been mentioned here: http://www.sql-ledger.com/cgi-bin/nav.pl?page=misc/faq.html&title=FAQ . Search for OID. If anyone knows a short cut, let us know. Regards Armaghan _______________________________________________ SQL-Ledger mailing list [email protected] http://lists.ledger123.com/mailman/listinfo/sql-ledger
