Forum OpenACS Q&A: Response to restore dump from 7.0.3 to 7.1.2 Problem
4: Response to restore dump from 7.0.3 to 7.1.2 Problem (response to 1)
Posted by Bob OConnor on 08/09/01 03:53 AM
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
sysdate ------------------------ 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/