On Miy, 2005-11-09 at 18:52 +0800, Tito Mari Francis Escaño wrote: > Greetings! > > Is there an issue on data handling compatibility between PostgreSQL 7.x and > 8.x? > > Would data dump from v7.x be acceptable to v8.x? > > Our test app was developed using 7.x, specifically 7.4.8. Now, knowing > the features of version 8.x, particularly 8.0.4, I think this will > have a long-term benefit for the server if no issue will hinder.
The good thing about Postgresql 8.x is that you don't need to manually reorder the statements dumped from Postgresql 7.x, unlike previous versions below 8.0 wherein the order of evaluation isn't really guaranteed. I've tried this when I tried porting the ERP I'm building from using Postgresql 7.4 to 8.0.4 (which has quite a lot of foreign keys, joins and views all over the place) and it didn't suffer a hiccup (well, save for the stored procedures, then again I didn't run createlang plpgsql dbname before I restored the database). -- Paolo Alexis Falcone <[EMAIL PROTECTED]> _________________________________________________ Philippine Linux Users' Group (PLUG) Mailing List [email protected] (#PLUG @ irc.free.net.ph) Read the Guidelines: http://linux.org.ph/lists Searchable Archives: http://archives.free.net.ph
