>>>>> "Joseph" == Joseph <syscon...@gmail.com> writes: Joseph> I need to drop the tables and rebuild with OIDS, can anybody Joseph> refresh my memory how to do it?
Joseph> I upgraded the Pg-tables.sql and trying to get rid of the Joseph> error: "ERROR: column "oid" does not exist" The only way I was able to do this was, for each table, create a new table with a new name, insert into newtable from oldtable, and then rename. I can't write the SQL from the top of my head, but if you like I'll look it up. Maybe someone else has a better solution. You could also restore a backup, I think. -- ] He who is tired of Weird Al is tired of life! | firewalls [ ] Michael Richardson, Sandelman Software Works, Ottawa, ON |net architect[ ] m...@sandelman.ottawa.on.ca http://www.sandelman.ottawa.on.ca/ |device driver[ ] panic("Just another Debian GNU/Linux using, kernel hacking, security guy"); [ ------------------------------------------------------------------------------ Come build with us! The BlackBerry® Developer Conference in SF, CA is the only developer event you need to attend this year. Jumpstart your developing skills, take BlackBerry mobile applications to market and stay ahead of the curve. Join us from November 9-12, 2009. Register now! http://p.sf.net/sfu/devconf _______________________________________________ Ledger-smb-users mailing list Ledger-smb-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/ledger-smb-users