On Fri, 2007-06-01 at 19:24 +0200, RW wrote: > I've never tried this but maybe it works if you use pg_dump > from 8.0 to do the dump. > > Greetings > Robert > > Robert Fitzpatrick wrote: > > I have a dump from 8.2 restored to file that was pg_dump'd with format c > > from a production server. I want to know if it is possible for me to > > restore this to a 8.0 development server where I am not able to upgrade > > at this time. Trying to do some testing, but this is the only other > > server that's available right now. I tried a normal restore and start > > getting errors relating to regclass: > > > > honeypot:~ # psql -U postgres trax < pgtrax.sql > > <snip> > > ERROR: cannot cast type text to regclass > > ERROR: relation "public.tblmenu" does not exist > > ERROR: function nextval(regclass) does not exist > > > > Is there a way I can prepare my dump to work? There is a lot of data, so > > I need to maintain COPY methods of inserting. Thanks for the idea, but it didn't work. It warned me when trying, I had to add the -i option to make it dump and I am getting the same ERROR's. -- Robert
