Forum OpenACS Q&A: Response to restore dump from 7.0.3 to 7.1.2 Problem

Posted by Bob OConnor on

Robin, I did check and I do have sec_id_seq as you described...and I turned on verbose (Don's suggestion). Further analysis led me to discover that the dual table is missing stuff. I can't do:

select sysdate from dual;
I get "(0 rows)" rather than
 2001-08-08 21:46:47-04
(1 row)

So where do I get the .sql code to restore the dual table?
and Robin, where did you find the code to restore the sequence?
I didn't find it in ~/www/doc/sql/

Thank you.