Forum OpenACS Q&A: Response to to_date and postgres-pgtcl
The problem with that is that your sequences will be screwed up. You'll have to drop a bunch of them and recreate them according to your dump file (that has the right values). I don't know an easy way around that. Anyone ?