On 9/11/06, Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> wrote:
I'd suggest two things. one: Get a better ERP... :) or at least one you can inject some intelligence into, and two: upgrade to postgresql 8.1, or even 8.2 which will be released moderately soon, and if you won't be going into production directly, might be ready about the time you are.
for 3 months I ran a 400M$ manufacturing company's erp off of a pre-beta 8.0 windows pg server converted from cobol using some hacked out c++ middleware. I remember having to change how the middleware handled transactions when Alvaro changed them to a checkpoint mechanism. I also remember being relieved when I no longer had to manually edit pg_config.h so nobody would notice they would notice they were running a beta version of postgresql had one of the technical people casually logged into psql. I scraped out almost completely unscathed except for a nasty crash due to low stack allocation of the compiler on windows. the point of all this? get onto a recent version of postgresql, what could possbily go wrong? merlin