Forum OpenACS Q&A: Response to Postgres troubles

Posted by Dan Wickstrom on
There is a bug in the way postgresql dumps out the db so that everything is not in the right order.  An easy way to fix it is to edit the dump file and move the sysdate function declaration to the top of the dump file.  You will also need to move the plpgsql function handler declaration to the top of the file, if you don't have it defined in your template database.  The function handler definition should come before the sysdate function declaration.  I think this problem is fixed in pg 7.1, so when it comes out you will no longer have this problem.