Now ... PG 7.2 would've made porting slightly easier (create or replace exists) and 9i with its support of SQL92 outer join syntax means we could've used generic db-independent SQL for those queries, easing our long-term maintenance problems.
What about coding style for new packages? Should we still write our code to run with 7.1's limitations (ie. should we still use DROP and CREATE instead of CREATE OR REPLACE)? Or is it pretty likely that a widespread upgrade to 7.2 will happen fairly quickly?