Forum OpenACS Q&A: to_date and postgres-pgtcl
7.0 with the --with-tcl option. Then, when I ran load-data-model.sql,
I uncommented i postgres-pgtcl. Had I been thinking, I probably
would've left it commented out. (I guess it's only required for
6.5.) Now, when the tcl calls to_date, postgres burps. My question
is what do I do now? I don't want to lose my database, I've already
got some valuable data in it. Can I manually make corrections?
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 ?